Thread: Adding 1 year and keeping time as well
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hugh G. Johnson Hugh G. Johnson is offline
external usenet poster
  
Posts: 2
Default 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





Reply With QuoteReply With Quote