MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Need formula to alert me when date is within 1 day of =today()


Posted by Noir on February 07, 2002 12:45 PM

In my speadsheet i have the date our next funding allocation will take place in cell C7 (EG:2/11/02. In cell A1 i have =Today().

I need a formula that will allow me to keep =Today() in cell A1 until 1 day from the date in C7 (This date will change each month). 1 day prior, =Today() should change to display the words "1 day remaining".

Please Advise.

Thx,
Noir


Posted by Juan Pablo G. on February 07, 2002 1:04 PM

How about this ? (In A1)

=IF(C7-TODAY()<=1,"1 day remaining",TODAY())

Juan Pablo G.

Posted by Yogi Anand on February 07, 2002 1:10 PM

Hi Noir:
Formula in A1 should be:
=if(today()=C7-1,"1 day remaining",C7)
Please post whether it works for you.

Yogi Anand
ANAND Enterprises (broken link)

Posted by Yogi Anand on February 07, 2002 1:18 PM

Sorry, Juan -- I did not see that you had already posted a solution, before I posted mine. Anyway, now she has two slightly differebt formulas that work!

Posted by Noir on February 07, 2002 1:31 PM

Sorry guy's, neither formula worked

Posted by Yogi Anand on February 08, 2002 8:59 AM

Re: Sorry guy's, neither formula worked

Noir, the formulas provided in the two responses appear to be correct for what you said you wanted to do. Please post what are you keying in cells C7, and A1 -- and let us see what is going on!