Forum Discussion
Macro for a month
Is it possible to create a keyboard shortcut in Excel 2019 (let's say Control-M) That would return the month following the date I enter the macro. for example: if I enter Control-M, today (November),...
A Macro may be a little overkill, here is a formula that will return do the same:
=+TEXT(EOMONTH(A1,1),"MMMM")&" Invoice"
This will look at a date in A1, then add one month onto that date, and return the new month + "Invoice". The text function is to format the date correctly. When using &, excel uses the general text format unless specifically stated.