I am trying to find how many 15th’s and 23rd’s between 2 calendar days?
Basically:
Example: if in one column I put 1/16/2018 and in one column put 3/20/2018, then last column would show 4.
Screen Shot 2018-12-23 at 9.40.27 PM.png
What would be the formula to get A and B to get C????
try
=DATEDIF(EOMONTH(A2-15,0),EOMONTH(B2-14,0)+5,"m")+DATEDIF(EOMONTH(A2-23,0),EOMONTH(B2-22,0)+5,"m")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Or try
=SUMPRODUCT(--(DAY(ROW(INDIRECT(A2&":"&B2)))={15,23}))
Or
=SUM(--(DAY(A2)<={15,23}))+SUM(--(DAY(B2)>={15,23}))+2*(MONTH(B2)-MONTH(A2)+(YEAR(B2)-YEAR(A2))*12)-2
Last edited by Bo_Ry; 12-24-2018 at 03:14 AM.
In C2
=SUMPRODUCT((DAY(ROW(INDIRECT(A2&":"&B2)))=15)+(DAY(ROW(INDIRECT(A2&":"&B2)))=23))
Pl see file. Date in dd/mm/yy format.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
This is perfect!!! Thank you guys!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks