Hi All,
Any help please on the below issue.
I have "Start Date" and "End Date" of an person who joins some institute for education, where there will be no holidays.
I have to calculate the number of days of the person.
Like if his Start Date was 21/03/2020 and End Date is 25/02/2021.
I have to get the days of the person for each and every month without any holidays and weekends.
From above example the number of days are like
2020 March-11 days
2020 April -30 days
2020 May -31 days
2020 June -30 days
2020 July -31 days
2020 Aug-31 days
2020 Sep-30 days
2020 Oct-31 days
2020 Nov-30 days
2020 Dec-31 days
2021 Jan -31 days
2021 Feb -25 days
I have already tried with @CalcMgrExcelNETWORKDAYS function but it is giving by removing the non working days.
Any other function which gives me as above please.
Regards,
Srikanth