Hi all,

Difficult one for wizards!

I am trying to compile a payroll for ships crew whose pay is calculated on a
30 day basis irrespective of calendar days in month. So for instance for the
month of february 08, assuming a salary of 1,000, and the crew member signed
on say 14 february his salary would be calculated on (29 days - 14 =15 days
pay) 15/30 x 1,000 or 500 or if he joined say on 17 march 08 (31 days - 17 =
15 days pay) again his salary would be 15/30 x 1,000 or 500.

Can someone assist in compiling a single formula which would work for any
set of dates during the year/s, including overlapping months say 14 Feb 08 to
17 Mar 08.

Many thanks/sgl