View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Ron@Buy Ron@Buy is offline
external usenet poster
 
Posts: 345
Default calendar in excel question?

Whoops! read cell 2 as B1

"Ron@Buy" wrote:

If the date you enter is in cell A1 in cell 2 enter =A1+60
Make sure both cells are formated to a 'date format'

"Nevermind" wrote:

If in one cell I enter date 12.6.2008., I need that the cell next to
automaticly calculate date which is 60 days from that date (in this case it
would be 12.8.2008?

How to do this?