tracking dates

smithrd6

Board Regular
Joined
Dec 13, 2005
Messages
150
Wanting to track a date cell entry and have another cell indicate "Y" if less than todays date or "N" if it is not.

thanks
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try like this

=IF(A1< TODAY(),"Y","N")<today(),"y","n")></today(),"y","n")>
 

Watch MrExcel Video

Forum statistics

Threads
1,108,491
Messages
5,523,255
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top