Help with some formulas

  • Thread starter Thread starter Miaka
  • Start date Start date
M

Miaka

Well I have this problem, I need to determine the number of *days* (if a
person's b-day hasn't passed during the current time) if the b-day
passed I need to leave a blank or tell "b-day passed"

I already have the age formula, The formula for the day of the week
he/she was born, total days that person has been living and an "if"
command to tell the words "Birthday passed" "Birthday hasn't passed"

I only need that last one and I don't know how to do it :confused:
 
If a person is, say, 23, then 23 birthdays have passed and their 24th
birthday has not - when do you want to start counting from?

Pete
 
Miaka,

If I understand you correctl and with the date of birth in G4 try:

=IF(DATE(YEAR(TODAY()),MONTH(G4),DAY(G4))-TODAY()=0,"Birthday
Today!",IF(DATE(YEAR(TODAY()),MONTH(G4),DAY(G4))-TODAY()>0,DATE(YEAR(TODAY()),MONTH(G4),DAY(G4))-TODAY()&"
Days","Birthday Past"))


--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Back
Top