Hi,
Attched example, have a start date (col E) & end date (col F) then months Dec-10 through to Jun-12 as columns heading from G-W. Looking for a a formula that will give me the number of days that fall between the start & end date for the month in the column heading, hoping someone can assist.
Many thanks
Branno
Assuming you include both start and end date in the count try this formula in G2 copied across and down
=MAX(0,MIN($F2,EOMONTH(G$1,0))-MAX($E2,G$1)+1)
Audere est facere
Please test carefully.
Let you know if this is what you want?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
You marked your question as solved.
Please respond if this (#3) what you up to.
Or did you use the solution of daddylonglegs?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks