Help with some formulas

[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

 

[Pete_UK]

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

 

[Sandy Mann]

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