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.

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

Mike, Perfect, thanks! Problem solved.

I do use Conditional Formatting just couldn't figure out the formula and the use of the TODAY function.

Ask Your Question

Weekly Poll