Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page End of the month if only the month is given End of the month if only the month is given
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
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: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
Try formatting A2 the way you want and using


=EOMONTH(DATEVALUE(A1&" 1, "&YEAR(TODAY())),0)
Reply With Quote
  #2  
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: 551
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

« Previous Thread | Next Thread »


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 02:23 PM.

Contact Us - Privacy Statement - Top

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