Return the last day of a given month

Hello all,

I'm sure there is a nice easy solution to this problem, but for whatever reason I've got a Monday brain and can't come up with a proper solution!

So I have a table with three columns. The first is the year of the item and the second is the given month. I need to fill in the third column with the date of mm/<last day of given month>/yy

I can't figure out a way to have Excel return the last day of the given month in a formula.

See attached for a quick demo of what I'm looking at.

Thank you very much in advance for your help!

Try

=TEXT(EOMONTH(DATE(B3,C3,1),0),"ddd")

It looks like you want the date, rather than th ename of the day, of the last day of tjh emonth. In which case - try this slight modification:

=TEXT(EOMONTH(DATE(B3,C3,1),0),"dd")

As for the second part of your query - try this:

=TEXT(EOMONTH(DATE(I14,MONTH(DATEVALUE(J14&" 1")),1),0),"dd")

i can't figure out a way to have excel return the last day of the given month in a formula.

Please Login or Register  to view this content.