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

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

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

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

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

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