Thread: [Solved] End of the month if only the month is given
View Single Post
 
Old 10-04-2021, 05:00 AM
NoSparks NoSparks is offline Windows 10 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