Create month-end date series- Cell A1: 10/31/09, Cell A2: =DATE(YEAR(A1),MONTH(A1)+2,0), copy down as needed.
Tag: Dates
Jul 29
Date Series Formula
This formula allows you to create a series of dates that alternate between the 15th and the last day of each month: =IF(B1=DATE(YEAR(B1),MONTH(B1)+1,0),DATE(YEAR(B1),MONTH(B1)+1,15),DATE(YEAR(B1),MONTH(B1)+1,0))