#1
|
||||
|
||||
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. |
#2
|
|||
|
|||
Try formatting A2 the way you want and using
=EOMONTH(DATEVALUE(A1&" 1, "&YEAR(TODAY())),0) |
#3
|
||||
|
||||
Thank you. I should have formatted the month using the DATEVALUE before the EOMONTH.
|
|
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 |