• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Easy formula for # of days in Month

Montrey

Montrey

Member
Just found this out and figured I'd share. I'm sure this has been posted before but just for those who haven't seen it.


If you use dynamic ranges and need to update monthly. Or if you have a file that you do daily and each month you need to know the # of days in the month.


Enter the first day of the month you want to know the # of days in a cell.

Then use this formula to find the # of days.

=day(eomonth(a1,0))


This is gonna be great for my dynamic ranges going forward.

Kind of newbie but w.e.
 
Just to clarify, you don't need to enter the first day of the month. You can enter any date within the month you want to know. Thanks for sharing Montrey!


For 2003 users, make sure the Analysis ToolPak add-in is active if you want to use the EOMONTH function.
 
For those 2003 users without the Analysis ToolPak add-in active, or just as an alternative


=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))
 
the craze of e-bookasme b31.1 are more seen among women as they are more likely to experiment with different colors and styles. if you want film star locks, model tresses or pop star looks then the hatsred bull hats are the ones for you.
 
the craze of e-bookasme b31.1 are more seen among women as they are more likely to experiment with different colors and styles. if you want film star locks, model tresses or pop star looks then the hatsred bull hats are the ones for you.
 
You must log in or register to reply here.
Back
Top