Given a specific start date (say Jan, 11th 2012 for example), I want to fill down a row in excel automatically with a date range matching the following pattern for the days (bi-monthly pay period).
1. 11th - 25th
2. 26th - 10th
Of course with actual dates in each cell including the month and year (not simply repeating the two values above). What I'm looking for is a way to put in one or two specific date ranges, such as:
January 11th, 2012 - January 25th, 2012
January 26th, 2012 - February 10th, 2012
And have excel automatically fill down many more cells in the same pattern:
January 11th, 2012 - January 25th, 2012
January 26th, 2012 - February 10th, 2012
February 11th, 2012 - February 25th, 2012
....
December 11th, 2012 - December 25th, 2012
How can I do this?