| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding 1 year and keeping time as well
Try this:
=EDATE(G2,12)+MOD(G2,1) -- Biff Microsoft Excel MVP "Hugh G. Johnson" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding 1 year and keeping time as well
=EDATE(G12,12)+MOD(G12,1)
or without using the ATP =DATE(YEAR(G12)+1,MONTH(G12),DAY(G12))+MOD(G12,1) -- Regards, Peo Sjoblom "Hugh G. Johnson" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding 1 year and keeping time as well
Excellent! This did the trick.
Thank you so much. Sincerely, Joe "T. Valko" wrote in message ... Try this: =EDATE(G2,12)+MOD(G2,1) -- Biff Microsoft Excel MVP "Hugh G. Johnson" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding 1 year and keeping time as well
On Wed, 20 Aug 2008 09:26:11 -0700, "Hugh G. Johnson"
wrote: 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 =EDATE(G2,12)+MOD(A1,1) --ron |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding 1 year and keeping time as well
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Hugh G. Johnson" wrote in message ... Excellent! This did the trick. Thank you so much. Sincerely, Joe "T. Valko" wrote in message ... Try this: =EDATE(G2,12)+MOD(G2,1) -- Biff Microsoft Excel MVP "Hugh G. Johnson" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
