I am trying to sequential dates over a period of months based on the given input date.
Current excel formula: =--(MONTH(B2+32) & "/" & DAY(B$2) & "/" & YEAR(B2+32))
Input date format: DD-MM-YYYY
Version: Microsoft office Home and Student 2019
Can someone please provide the excel formula for this?
30-Sep-2022
. Do you want subsequent dates to be on the 30th? or on the last day of the month? What about30-Jan-2022
. If your dates will always be prior to the 28th, then there should not be an issue, but if not, think carefully about what you want.IF
to determine whether to use anEDATE
function or, possibly theEOMONTH
function