Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-04-2021, 04:45 AM
Marcia's Avatar
Marcia Marcia is offline End of the month if only the month is given Windows 10 End of the month if only the month is given Office 2019
Expert
End of the month if only the month is given
 
Join Date: May 2018
Location: Philippines
Posts: 526
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
  #2  
Old 10-04-2021, 05:00 AM
NoSparks NoSparks is offline End of the month if only the month is given Windows 10 End of the month if only the month is given Office 2010
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Try formatting A2 the way you want and using
=EOMONTH(DATEVALUE(A1&" 1, "&YEAR(TODAY())),0)
Reply With Quote
  #3  
Old 10-04-2021, 05:09 AM
Marcia's Avatar
Marcia Marcia is offline End of the month if only the month is given Windows 10 End of the month if only the month is given Office 2019
Expert
End of the month if only the month is given
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Thank you. I should have formatted the month using the DATEVALUE before the EOMONTH.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
End of the month if only the month is given 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
End of the month if only the month is given Day and Month to Uppercase Andy2011 Word VBA 1 07-22-2011 04:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft