How to write a formula to show the "last date" of a month

[Guest]

I want to design a spreadsheet where I only need to enter the "month" and
"year" as the starting point, then the formula will yield the "last date" of
the months (starting from the month entered). For example, if I entered "11"
for month and "2007" for year, then I want excel to yield "11/30/2007",
"12/31/2007", "1/31/2008", etc.

How do I write this formula?

Thank you!

 

[Bernard Liengme]

An odd little trick is to use day zero of next month to get last day of
month of interest
=DATE(B1,A1+1,0) with month (11) in A1 and year (2007) in B1
best wishes

 

[Guest]

Hi Bernard - you're a genius!!! This formula works wonders!!! Thank you
very much. Mary