"TUNGANA KURMA RAJU" wrote in
message ...
I am working on a personal worksheet.In cell A1 I put my Date of
birth(1-NOV-1975) in ddmmmyyyy format.What formula I need to write to
get(in
B1 to B6)
1.What date will be my next birth day?(output:1-NOV-2005)

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

2.What day it will be?(output:Tuesday)

=TEXT(B1,"dddd")

3.How many days left for my upcoming birth day?(output:21 days)

=B1-TODAY()

4.Whether today is my birth day or not?(output:no)


5.What will be my upcoming birth day's ordinal?(output:30th)

=IF(B1=TODAY(),"","no")

6.Date of my earliest upcoming birth day that falls on sunday?(say
1-NOV-2008)