Solved Excel Formula: Help with IF using current date

March 12, 2014 at 09:03:39
Specs: Windows 7
I am using a spreadsheet to track tasks and would like to automatically change the status of the task to "Due" when current date is 15 days from the task due date, and "Late" when current date is equal to or after the task due date.

Thank you in advance for your assistance.


See More: Excel Formula: Help with IF using current date

Report •

#1
March 12, 2014 at 09:46:24
✔ Best Answer
With your Deadline Date in cell A1 enter this formula in B1:

=IF(A1-TODAY()<=0,"Late",IF(A1-TODAY()<15,"Due",""))

See how that works for you.

If you want a more Colorful way to notify you of an upcoming deadline,
try using Conditional Formatting to color the cell, see this How-To:

http://www.computing.net/howtos/sho...

MIKE

http://www.skeptic.com/


Report •

#2
March 12, 2014 at 10:01:49
Mike,

Perfect, thanks! Problem solved.
I do use Conditional Formatting just couldn't figure out the formula and the use of the TODAY function.


Report •
Related Solutions


Ask Question