Solved Recurring BI-weekly date formula?

April 11, 2009 at 08:18:20
Specs: Windows XP
I am trying to create a recurring date formula in Excel. i am setting up a bi-weekly "budget" and want to have the spreadsheet automatically update with next bi-weekly date. Starting on Friday 4/24/09, and then moving every 2 weeks from then on. So, the next date would be Friday 5/8, and so on. Any help that someone can provide is greatly appreciated!

See More: Recurring BI-weekly date formula?

Report •


#1
April 11, 2009 at 09:31:42
✔ Best Answer
Just add 14 days to the previous date.

=+A1+14

A1 contains the previous date. Dates have to be formated as dates and not entered as strings. Datas are stored in Excell as a 32 bit floating point number. You cannot do calculations on strings.

Stuart


Report •
Related Solutions


Ask Question