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!

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Mary Y" wrote in message
...
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!

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


"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Mary Y" wrote in message
...
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!