How to get next month in macros

Help
3

If you want to have the last day of the next month:

  • Using Excel formula:
    =EOMONTH(TODAY(),1)
    with format: =TEXT(EOMONTH(TODAY(),1),“mm.dd.yy”)

  • Using VBA macro:
    Application.WorksheetFunction.EoMonth(Date, 1)
    with format: Format(Application.WorksheetFunction.EoMonth(Date, 1), “mm.dd.yy”)

1 Like