Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Format - Conversion | Excel Discussion (Misc queries) | |||
Date Conversion | Excel Worksheet Functions | |||
Date conversion issue "^" symbol | Excel Discussion (Misc queries) | |||
Date Conversion | Excel Discussion (Misc queries) | |||
unwanted number to date conversion while pasting data from web | Excel Worksheet Functions |