EXCEL - calclating every 28 days

  Dirty Dick 17:56 26 Feb 10
Locked

A friend has asked me (and now I'm asking you!) how to calculate from a date every 28 days, Say an invoice goes out on the 1st Feb 2010, and susequent ones go out every 28 days. Is there a way to calculate this in Excel?

Thanx

DD

  VoG II 18:10 26 Feb 10

With a date in A1

=A1+28

will add 28 days. Format the result cell as Date if Excel doesn't do this automatically.

  Dirty Dick 10:56 27 Feb 10

So easy when i think about it

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

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

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…