=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?