gssachin
Board Regular
- Joined
- Nov 14, 2013
- Messages
- 155
Hi,
I want to pay a salary of 50000 INR pm from 10-04-2020 to 18-08-2020. We are calculating working days for April, may, June, July & Aug after removing Fridays (i.e. for apr – 26 days, may – 26 days, jun & July -26 days & Aug 27 days
I m using networkdays.int formula for calculating days
i.e. NETWORKDAYS.INTL(10-04-2020,(18-08-2020-1),16) = 112 days
so I need formula/macro to calculate this so system will calculate
(10-04-2020 to 30-04-2020)/26* Amt (April working days after removing Friday )
(01-05-2020 to 31-05-2020)/26* Amt (May working days after removing Friday )
(01-06-2020 to 30-06-2020)/26* Amt (June working days after removing Friday )
(01-07-2020 to 31-07-2020)/26 * Amt (July working days after removing Friday )
(01-08-2020 to 18-08-2020)/27 * Amt (Aug working days after removing Friday )
I want to pay a salary of 50000 INR pm from 10-04-2020 to 18-08-2020. We are calculating working days for April, may, June, July & Aug after removing Fridays (i.e. for apr – 26 days, may – 26 days, jun & July -26 days & Aug 27 days
I m using networkdays.int formula for calculating days
i.e. NETWORKDAYS.INTL(10-04-2020,(18-08-2020-1),16) = 112 days
so I need formula/macro to calculate this so system will calculate
(10-04-2020 to 30-04-2020)/26* Amt (April working days after removing Friday )
(01-05-2020 to 31-05-2020)/26* Amt (May working days after removing Friday )
(01-06-2020 to 30-06-2020)/26* Amt (June working days after removing Friday )
(01-07-2020 to 31-07-2020)/26 * Amt (July working days after removing Friday )
(01-08-2020 to 18-08-2020)/27 * Amt (Aug working days after removing Friday )