Hello,
I need to find Number of Mondays inside dates provided.
Start date: 4/20/2020 and End Date: 5/18/2020 = Result: 5 ( Including both Start and End dates since both are Mondays)
Start date: 5/25/2020 and End Date: 6/15/2020 = Result: 4 ( Including both Start and End dates since both are Mondays)
But i am not getting it correctly. I tried below formula..,
=ED-SD-NETWORKDAYS.INTL(SD,ED,12)+1
I need to find Number of Mondays inside dates provided.
Start date: 4/20/2020 and End Date: 5/18/2020 = Result: 5 ( Including both Start and End dates since both are Mondays)
Start date: 5/25/2020 and End Date: 6/15/2020 = Result: 4 ( Including both Start and End dates since both are Mondays)
But i am not getting it correctly. I tried below formula..,
=ED-SD-NETWORKDAYS.INTL(SD,ED,12)+1