Hi All,
I want to built a formula which will list all working days in a month excluding weekends .i.e. saturdays and sundays and it will also exclude the list of the dates present in a different column .i.e. the holidays in that month and give us a list of working days. I have the below formula which will list down the dates excluding the weekends in a month if I put the first working day over it. for e.g. if my date is in cell A1 and cell A2 I enter the below formula and drag it down then it will give me the list of all working days.
=IF(WEEKDAY(A1+1,2)<6,A1+1,IF(WEEKDAY(A1,2)=6,A1+2,A1+3))
I don't want to use the Networkdays as for that I will have to select analysis tool addin in the excel and if i send the same file to some other person and if the above addin is not selected in his excel then he will get #name error. So I want to build a formula without using networkdays from analysis tool.
Thanks a lot for your help in advance.
I want to built a formula which will list all working days in a month excluding weekends .i.e. saturdays and sundays and it will also exclude the list of the dates present in a different column .i.e. the holidays in that month and give us a list of working days. I have the below formula which will list down the dates excluding the weekends in a month if I put the first working day over it. for e.g. if my date is in cell A1 and cell A2 I enter the below formula and drag it down then it will give me the list of all working days.
=IF(WEEKDAY(A1+1,2)<6,A1+1,IF(WEEKDAY(A1,2)=6,A1+2,A1+3))
I don't want to use the Networkdays as for that I will have to select analysis tool addin in the excel and if i send the same file to some other person and if the above addin is not selected in his excel then he will get #name error. So I want to build a formula without using networkdays from analysis tool.
Thanks a lot for your help in advance.