How to get next month in macros

i want to get next month as August 19
how to do it

1 Like

Here it is @brindhaS,

The required string you can get using this:
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),“mmmm”&" "&“YY”)

Use this to get the next month value =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),“mmmm”)

If you want it as number, use

1 Like

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

  • Using Excel formula:
    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