I am trying to figure out how to do this in the cleanest way possible. I need a formula that will output biweekly dates or the last working day of the Month only if a biweekly date does not land on that date and it occurs before the next biweekly date. The first date in the list will be manually entered and the formula will use that as the first date. For example:
May 15, 2014 (Manually entered)
May 29, 2014 (Formula that output the next biweekly date based on previous cell)
May 30, 2014 (Same Formula that outputs last working day of month based on last date)
June 12, 2014 (..and so on)
June 26, 2014
June 30, 2014
July 10, 2014
July 24, 2014
July 31, 2014
I hope this makes sense. I would prefer to do this using a formula instead of VBA.