Hi,
Hopefully someone can help. I have a data set with date range (from to To date) and i needed to know a formula which can tell how many days fall for each month
i was looking for formula to give me total for every month as in highlighted yellow section. sorry if i am not able to explain properly
Capture.JPG
Formula:
Please Login or Register to view this content.
Custom format the cell to dd
-----------------
2022-06-19_9-19-53.jpg
@Dave
I don't think that's what the OP wants. The expected results are in cells H2 to S5, I believe.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
AliGW - Hi, yes you are right that is what i am looking for. Thanks
Oh, I am thinking the OP wants to calculate how many days are in a month so he can calculate the days remaining for the job(F:F) for the next month.
H2=IFERROR(SUMPRODUCT(--(MONTH(ROW(INDIRECT($D2&":"&$E2)))=MONTH(H$1))),"")
Copy across and down
1/9/2022 to 2/5/2022 days 28 not 27
CARACALLA - Thank You, much appreciated.
Try this H2=MAX(0,MIN(EOMONTH(H$1,0),$E2)-MAX(H$1,$D2))+IF(AND(H$1>EOMONTH($D2,0),H$1<=$E2),1,0)< copy across and down.
josephteh - Thank You
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks