Excel Date Formula

S

Steve

Can I write a formula to check a cell reference to see if
the date it contains is more than 120 days before today?
 
F

Frank Kabel

Hi
try
=IF(A1<TODAY()-120,"more than 120 before today","within 120 days")
if A1 is the cell to check
 
Top