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 •

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


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.


Report •
Related Solutions

Ask Question