| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding 1 year and keeping time as well
I have a column of date and time stamps I want to add excatly 1 year to.
The cell I want to add a year to is has this: 6/1/2007 6:35 If I use the forumula =EDATE(G2,12) I get 6/1/2008 12:00 AM How do I get it to leave the time along or carry that accross as well? Sincerely Hugh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| KEEPING THE TOTAL IN C3 WHEN ADDING B3 | Excel Discussion (Misc queries) | |||
| KEEPING THE TOTAL IN C3 WHEN ADDING B3 | Excel Discussion (Misc queries) | |||
| Adding columns w/new formulas BUT keeping subtotals | Excel Discussion (Misc queries) | |||
| adding new rows and keeping same formulas | Excel Discussion (Misc queries) | |||
| adding new rows and keeping the same formulas | Excel Worksheet Functions | |||
Threaded Mode
