Stephanie
if the date is in cell A1, try:
=DATE(2005,MONTH(A1),DAY(A1)+15)
but note that dates late in December could generate dates in 2006
Regards
Trevor
"Stephanie Myers" wrote in
message ...
Help! I am trying to convert a birthday to 15days out 2005.
For example, I have a birthday 7/15//1942 and I want to make it so that it
converts it to 7/30/2005.
How should I set up the excep spreadsheet for this kind of computation?
I am lack technical computer verbage, so please spell it out for me.
Thanks much,
Stephanie Myers
|