No of days between two dates

[Dgavilanes]

This Q? is for Pat Hartman.(He is the man)
Need to calculate the difference between two dates.
The trick is.
Is based on 21 pay periods in a yr. 10 days per period (210 days total)
if someone gets pay on a monday - Friday
Sunday date is used for beginning date.
and Saturday is used for ending date.
(thats the way it is) and thats how I get the paperwork.
any help will be greatly appreciated.

thank you
Dennis

Ps I do have a code that calculates the difference between two working dates, but is based on a 7 day week.

 

[Dgavilanes]

I get paperwork with salary adjustments,
dates range between 01/01/99 to 06/25/02.
These people are teachers their salary need to be updated and we calculate the difference between the effective date (their adjustment has been granted)to the end of the school yr, (06/25/02)
will this help you?
thanks