Next occuance

  • Thread starter Thread starter Frustrated User
  • Start date Start date
F

Frustrated User

I am trying to create a spreadsheet list of client birthdays. I need a col
titled Date of Birth (this is obviously just data entry). The next col
needs to be Next Birthday and then one for age. I have the calculation
formula done for the age col. Is there an easy way to fill-in the values
for the "Next Bday" col?
 
Hi

One way
=IF(DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))<TODAY(),
DATE(YEAR(TODAY())+1,MONTH(A1),DAY(A1)),
DATE(YEAR(TODAY()),MONTH(A1),DAY(A1)))
 
Perhaps this:
=IF(--TEXT(A1,"dd-mmm")<=TODAY(),--TEXT(A1,"dd-mmm"),--(TEXT(A1,"dd-mmm-")&(YEAR(TODAY())+1)))

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
Well...THAT formula was wrong!

Try this:
=TODAY()+LOOKUP(365,--(TEXT(A1,"dd-mmm-")&(YEAR(NOW())+{0,1}))-TODAY())

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
I am trying to create a spreadsheet list of client birthdays. I need a col
titled Date of Birth (this is obviously just data entry). The next col
needs to be Next Birthday and then one for age. I have the calculation
formula done for the age col. Is there an easy way to fill-in the values
for the "Next Bday" col?
Click to expand...


=DATE(YEAR(TODAY())+(DATE(YEAR(TODAY()),MONTH(DOB),
DAY(DOB))<=TODAY()),MONTH(DOB),DAY(DOB))


--ron
 
Back
Top