Thread: Date conversion
View Single Post
  #2   Report Post  
Trevor Shuttleworth
 
Posts: n/a
Default

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