| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Dates
I have a date displayed in a cell as 3/3/2005. I would like to add the value
of another cell, i.e. 36 (months) and display the result 3/3/2008. Can someone help? |
|
#2
|
|||
|
|||
|
=DATE(YEAR(A1),MONTH(A1)+36,DAY(A1))
where A1 holds 3/3/2005 -- Regards, Peo Sjoblom (No private emails please) "sdmccabe" wrote in message ... I have a date displayed in a cell as 3/3/2005. I would like to add the value of another cell, i.e. 36 (months) and display the result 3/3/2008. Can someone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
| Finding dates within a date range | Excel Worksheet Functions | |||
| Plotting Dates | Excel Worksheet Functions | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| due dates | New Users to Excel | |||
Linear Mode
