excel date function

  theearlofsabden 14:48 13 Mar 2010
Locked

Hi guys

Trying to calculate =edate in excel

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

A1
01-SEPT-09
A2
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

Thanks
Neil.

  VoG II 15:29 13 Mar 2010

A3=A2+70

  Terry Brown 15:30 13 Mar 2010

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
done

  theearlofsabden 15:36 13 Mar 2010

Thank you both

As easy as that.....

Much appreciated

Neil.

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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017