how to use an Today() statement in an IF() statement in Exce

March 10, 2012 at 23:02:10
Specs: Windows Vista
I am trying to calculate an age of a person, see if the person is 55 yrs. or older and if the person is state true if not state false. I'm trying to use the if statement, but if anybody can suggest using a different statement. I'd really appreciate the help.

See More: how to use an Today() statement in an IF() statement in Exce

Report •


#1
March 11, 2012 at 01:14:50
The DATEDIF function is an undocumented function in Excel. The only version where it was included in the Help files was Excel 2000. It is not even included in the later version's function lists, but it still works in all versions.

You can find a great write-up on it here:

http://www.cpearson.com/excel/dated...

This should get you what you are looking for:

=IF(DATEDIF(A1,TODAY(),"y")>=55,TRUE,FALSE)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question