View Single Post
  #1   Report Post  
HeatherDawn
 
Posts: n/a
Default How do I break a date range by month?

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