Thread: [Solved] End of the month if only the month is given
View Single Post
 
Old 10-04-2021, 04:45 AM
Marcia's Avatar
Marcia Marcia is offline Windows 10 Office 2019
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default End of the month if only the month is given
Hi. A1 contains the name of the month entered manually in general format. I would like a formula in A2 that gives the end of the month and the current year.
Say: A1 September
A2: September 30, 2021
When I change September to August
A2: August 31, 2021
I tried the EOMONTH function but it gives an error message.
Thank you.
Reply With Quote