|
|
#1
10-04-2021, 04:45 AM
|
||||
|
||||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Calculate the first day of next month
|
Maramaschino | Word | 1 | 03-11-2021 04:16 PM |
| Countif containing specific month | baes10 | Excel | 3 | 03-26-2018 06:33 PM |
| Average for the month | joflow21 | Excel | 4 | 10-21-2013 06:57 AM |
| How to show just day and month | ketanco | Project | 2 | 06-14-2012 03:25 PM |
|
Day and Month to Uppercase
|
Andy2011 | Word VBA | 1 | 07-22-2011 04:34 PM |
Windows 10 
Office 2019
Threaded Mode