Help with some formulas
 

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:


--
Miaka
------------------------------------------------------------------------
Miaka's Profile: http://www.excelforum.com/member.php...o&userid=33885
View this thread: http://www.excelforum.com/showthread...hreadid=536640

Help with some formulas
 

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

Help with some formulas
 

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


with @tiscali.co.uk


"Miaka" wrote in
message ...

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:


--
Miaka
------------------------------------------------------------------------
Miaka's Profile:
http://www.excelforum.com/member.php...o&userid=33885
View this thread: http://www.excelforum.com/showthread...hreadid=536640