Hi,

I'm confused by the logic of this. If somene starts on 14/2/2008 then they
don't work 13 days of that month so do work 16 not 15 as in your example.

In your second example 31-17=14 not 15

That aside try this
=IF(DAY(A1)=1,B1,((EOMONTH(A1,0)-A1+1)/30)*B1)
If you get the name error then load the analysis toolpak.


I don't understand the second part of your question

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.

Mike



"sgl" wrote:

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