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

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 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
 

« 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 12:22 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