I have MC Excel 2007 version. These functions aren't available in earlier versions. The only time it returns the first of the next month is when the source date was the first day of the current month. Further details on your benefit options will be provided during your New Employee Orientation. Back to, =IF(DAY(EDATE(A2,1))