Where does 4 come from?

Where is the num days stored?

Do weekends count?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"AG" wrote in message
...
I'm trying to figure out a formula for annual leave.
I need it to calcultate for the month. For example:

Days 1 thru 6 would = 0.5
7-12=0.5
13-18=0.5
19-24=0.5
25-31=0.5
Equaling 2.5 days for a month. If the start date is 4 jan 05 and the end
date is 15 feb 05 the total would be 4.0 total days earned