Hi,
I'm hoping you can help me. I need to create a cell which says either yes, or no when today's date is within 60 days before another date in the future. Its to basically remind me when a certain license is due to expire and will give me time to organise myself.. So if today's date is within 60 days or less or a cerain date, i want a cell to warn me.
Hope you can help.. I'm struggling a little
Warning When Date Not With Date Range
-
-
-
Re: Display Warning When In Date Range
Assuming A1 = Today's date and B1 = the due date: =IF(B1-A1<=60,"Due","")
-
Re: Display Warning When In Date Range
Assuming your future date is in D1:
=IF(TODAY()>=D1+60,"Yes","No") -
Re: Display Warning When In Date Range
Thanks - Works a treat, only it still shows due within 60 days after the date.. Is there a way to change that?
-
Re: Display Warning When In Date Range
Quote. . . only it still shows due within 60 days after the date.. Is there a way to change that?
I assume you are referencing Simon's formula. The formula I gave you will not show "due" if the difference between TODAY() and your future date is greater than 60 day, it will show a blank. If the difference between the TODAY() and the future date is less than or equal to 60, then it will display "due". There is nothing to change for this formula. -
-
Re: Display Warning When In Date Range
Why not use Data>Validation to PREVENT a wrong date and/or Conditional Formatting to flag them.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!