calculate age on certain date

  • Thread starter Thread starter JWCrosby
  • Start date Start date
J

JWCrosby

I have the formula for calculating an age based on a
birthdate, but I also need one that returns the person's
age on March 1 of the current year. Suggestions?
 
I have the formula for calculating an age based on a
birthdate, but I also need one that returns the person's
age on March 1 of the current year. Suggestions?
Click to expand...

Try this:

DateDiff("yyyy", [DOB], DateSerial(Year(Date()), 3, 1)) -
IIF(Month([DOB]) < 3, 1, 0)
 
Back
Top