excel date function

  theearlofsabden 14:48 13 Mar 10

Hi guys

Trying to calculate =edate in excel

I have the following set up;
(I need to show a run of 10 week dates)

01-NOV-09 =EDATE(a1,2) to show 2 months after 01-sept-09

How do I make A3 to show 10 weeks after A2


  VoG II 15:29 13 Mar 10


  Terry Brown 15:30 13 Mar 10

If you want to show periods 10 weeks apart, the easiest option is to put the first date in A1.
Highlight down as many times as you need.

Go to EDIT , Fill, Series, in the box enter 70 (10 x 7 days), OK

  theearlofsabden 15:36 13 Mar 10

Thank you both

As easy as that.....

Much appreciated


This thread is now locked and can not be replied to.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Fresh New Fonts of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced