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

[email protected]
[email protected] with @tiscali.co.uk


"Miaka" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> Miaka
> ------------------------------------------------------------------------
> Miaka's Profile:
> http://www.excelforum.com/member.php...o&userid=33885
> View this thread: http://www.excelforum.com/showthread...hreadid=536640
>