ExcelBanter - formula for # of days between two dates-Excel 2000

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula for # of days between two dates-Excel 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/148477-formula-days-between-two-dates-excel-2000-a.html)

Kelley

formula for # of days between two dates-Excel 2000

I want to know which employee is 19 years old or older based on a 365 day
year. Can't figure it out. Please help. Thanks.

Peo Sjoblom

formula for # of days between two dates-Excel 2000

=DATEDIF(DOB,TODAY(),"y")=19

will return TRUE if 19 and older

--
Regards,

Peo Sjoblom

"kelley" wrote in message
...
I want to know which employee is 19 years old or older based on a 365 day
year. Can't figure it out. Please help. Thanks.

All times are GMT +1. The time now is 12:41 PM.