Hi guys,
I would like a formula or other method that would give me the amount of days that fall within a particular month based on a start date and a end date.
For example:
I would like to know that 5 days belong to February and 3 days to March.
Please Login or Register to view this content.
Thanks in advance
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
Try this user defined function which you should paste into a blank module
Then call this in the sheet, for example, for MarchPlease Login or Register to view this content.
=DaysInMonth(A1,B1,3)
Martin
Excellent!
Thanks a mill mrice
Portuga,
U can get an Excel Solution like this...
If your Starting Date and End Dates are in cells A2 and B2 then you can use the following formula.
[ ="There are "&(DATE(YEAR($A$2),MONTH($A$2)+1,0)-$A$2+1)& " days in the month of "&CHOOSE(MONTH($A$2),"Jan","Feb","Mar","Apr","May","June","July","Aug","Sep","Oct","Nov","Dec")&" and "& $B$2-DATE(YEAR($B$2),MONTH($B$2),1)+1&" days in the month of "& CHOOSE(MONTH($B$2),"Jan","Feb","Mar","Apr","May","June","July","Aug","Sep","Oct","Nov","Dec")&"." ].
Please let me know if this works for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks