=DATE(YEAR(start),MONTH(start)+1,0)-start+1

and

=end-DATE(YEAR(end),MONTH(end),0)

--

HTH

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


"HeatherDawn" wrote in message
...
I am trying to calculated the days in a month for a 14 day pay period.
What
I want to do is to calculate how many days are in each month if the pay
period crosses a month. For example the begining date is 8/21/05 and it
ends
9/3/05. I was wondering if there is a formula that will allow me to
calculated that there are 3 days in Sept and 11 in August. Thanks