Counting down to a deadline? Use the TODAY() function — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Counting down to a deadline? Use the TODAY() function

by on
in Excel Training,Office Technology

Counting down to a deadline? Use the TODAY() function to automatically tell you how many days until your goal date.

The TODAY() function has no arguments, but still needs the parentheses. This function uses whatever date your computer thinks is today. So if your target date was in A2, in B1 you might have the formula =TODAY()-A2. You can even use Conditional Format­­ting to make that number turn red or highlight yellow when it is getting close, for example. Click the Con­­di­­tional For­­matting button, Highlight Cells Rules, Less than … and input the number of days you would consider “getting close.”

Leave a Comment