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)
2.What day it will be?(output:Tuesday)
3.How many days left for my upcoming birth day?(output:21 days)
4.Whether today is my birth day or not?(output:no)
5.What will be my upcoming birth day's ordinal?(output:30th)
6.Date of my earliest upcoming birth day that falls on sunday?(say 1-NOV-2008)
For me I tried with date formulas.some gave output errors ,numbers.
office xp version,widows me.