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!
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