display days in month in the cell according to date
I need a formula to display the days in the month in the cell according to the month of a date in another cell. For example: if the date in the C4 is in the month of December the cell B4 should be 31 representing the days in that month. If the date is in November the cell B4 needs to be 30 to represent the 30 days of November.
Thanks do much for the help!
Last edited by mraines; 12-05-2012 at 09:48 AM. Reason: Fixed
You can put this formula in B2:
Formula:
Please Login or Register to view this content.
then copy down. Note that I have avoided using any of the ATP functions, for backwards compatibility.
Hope this helps.
Pete
=day(eomonth(c2,0))
If C2 is 1st of the month, as per your examples then you can get the number of days in that month with this formula
=32-DAY(C2+31)
format as general
Audere est facere
Thank you so much! These will work great!
You're Welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks