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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates - Need to display date one month prior to user-entered date 13
help with Sum in between dates 9
Formula to figure out months between two dates 3
date function 10
Partial Year Adjustments (Mod Function) 1
Specify a column by the month to calculate it's data 5
Date 2
Please help with formula (multiple ifs to determine due date) 3

Back
Top