Calculate Days

[Neeraj Dhiman]

Hi All,

I have two dates first date is (start date) ex. 03-mar-2019 and second date (End date) is 31-Dec-2019.

Here is the confusion i want to check only for the month of Oct'19 how many working days are there. Days should be calculated base on the start date and end date as both date are dynamic in nature i might change them frequently.

I tried so many IF combination but not getting the one line formula.

Please help me. Waiting for your responses

 

[shrivallabha]

Your setup and requirement is bit unclear.

Suppose in cell
A1: 03-Mar-2019
B1: 31-Dec-2019
C1: 01-Oct-2019 (start date of the month you are interested in)
then you can try:
=NETWORKDAYS(MAX(A1,C1),MIN(B1,EOMONTH(C1,0)))

 

[Neeraj Dhiman]

Your setup and requirement is bit unclear.

Suppose in cell
A1: 03-Mar-2019
B1: 31-Dec-2019
C1: 01-Oct-2019 (start date of the month you are interested in)
then you can try:
=NETWORKDAYS(MAX(A1,C1),MIN(B1,EOMONTH(C1,0)))

thanks Shrivallabha its working fine Cheers