ExcelBanter - dates into ages

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - dates into ages (https://www.excelbanter.com/excel-worksheet-functions/74285-dates-into-ages.html)

Caz

dates into ages

Column D is date received.
Column E is DOB.
What formula do I use to calculate the date of birth to land in column F?

Peo Sjoblom

dates into ages

=DATEDIF(DOB,Received,"y")

will give you the year

http://www.cpearson.com/excel/datedif.htm

descriptions

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

"Caz" wrote in message
...
Column D is date received.
Column E is DOB.
What formula do I use to calculate the date of birth to land in column F?

All times are GMT +1. The time now is 07:03 PM.