Formula Question (MPS)

  • Thread starter Thread starter Michael P. Smith
  • Start date Start date
M

Michael P. Smith

i have a formula i use in a spreadsheet...
= IF(YEAR(O$1)-YEAR(E3)=105,,YEAR(O$1)-YEAR(E3))

I use it to caculate ages where the current date is in cell O1 and the
Person's birthday is shown in cell E3.

It doesn't add up right because if the birthday is later in the year
than the current day (shown in cell O1. ) It works fine if the
birthday is. If the birthday has already happened this year, then the
formula works fine.

How shoud i adjust it? thanks.

Mike
 
Thanks for the two SPEEDY replies.. i wasn't going to check for a few
days, then just for the heck of it i checked now! thanks!!

That works great, and corrects the problem... but i have one more
thing to ask, add? Is there a way that if there is no date added, as
in you haven't filed it out yet, that it didn't return the number 105?

This is a spread sheet that i will be updating often... and when i
look at lines that are blank it shows the number 105 in the age box.
this isn't a huge issue, but i was wondering if there was a way around
this.

Mike
 
Back
Top