Discussion Locked

Dates in EXCEL

0 helpful

2 replies

by rwilliamthorne Dec 29, 2004 last reply Sep 14, 2007

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is it possible to type "January 2005" and get the number of days in the month? Do I need a macro or is there a formula to get these results?

2 replies

Why would you want to do that? January has 31 days, no matter what year you enter.

keep the date value in the cell A1

then type the following formulae in any cell

=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)

This discussion is closed to new replies.