Skip to Content
0
Former Member
Apr 02, 2014 at 07:53 AM

Time PCR to calculate number of days in a month excluding sundays

536 Views

Hi All,

Below is my requirement:

For each month employee is eligible for maximum of 1.5 days of quota. but, this 1.5 days should be accrued on daily basis except sundays. also, this 1.5 days would be divided by number of days in a month except sunday

for example, March 2014 has 31 days out of which we have 5 Sundays . so, 31-5 = 26 days. Hence, 1.5/26 = 0.05769 days would be accrued each day for each employee except sundays (no quota should be accured if it is sunday)

Similarly, for May 2014 it would be 31-4 = 27 . so, 1.5/27 = 0.05555 days would be accrued each day for each employee

Could you please advise how to write a PCR for the above requirement, can we calculate number of days in a month excluding Sundays..?

Thanks in advance!

BR,

Prem

(Prassu4u2003@yahoo.co.in)