r/excel•
Fanatical_reez

IF date is within one month of today's date, return YES, otherwise, return NO

unsolved

I'm trying to use a spreadsheet to determine if supply is close to expiration. I want to use IF to determine if the expiration date is within one month of today's date, but I'm having trouble formatting the IF formula. Here's what my spreadsheet looks like:

https://preview.redd.it/rrr0k2yv1scg1.png?width=1636&format=png&auto=webp&s=f642d41e37f2f9f2d163309283a04cda51dcc413

Posted Jan 11, 2026, 8:09 PM UTC

2812
Loading comments…