I get 5 for 29th May. I do get 4 for 31Jul, but I don't understand why you
think it is 5.

--

HTH

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


"Big Rick" wrote in message
...
I have changed B37 to B5 as that is the first cell of the date column.
The formula gives me 5 for every month.
Please can you help me further.

Please see examples of correct 4 or 5 week months. All for 2006
Month 1 3 apr to 30 apr
Month 2 1 may to 28 may
Month 3 29 may to 2 jul (5 week)
Month 4 3 jul to 30 jul
Month 5 31 jul to 3 sep (5 week)

Thanking you in anticipation
--
Big Rick

"Bob Phillips" wrote:

=4+(DATE(YEAR(B37+28),MONTH(B37+28)+1,0)-(B37+28)3)

--

HTH

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


"Big Rick" wrote in message
...
In my current timesheets, I have to manually decide wether each month
is 4
or
5 week month. I simply do this by putting a 4 or 5 in $A$44.
The formula I have in the date cells (B37:B43) is
=IF($A$44=4,"---",$B$5+28 =IF($A$44=4,"---",$B$5+29 etc

The criteria for wether it is a 4 or 5 week month is as follows.
e.g. 1
B37 = 1 May 06. Therefore B35 will be 28 May 06.
It is then only 3 days till the actual end of month making this a 4
week
month.

e.g. 2
b37 = 29 May 06. Therefore B35 will be 25 June 06.
It is then 5 days till the actual end of month making this a 5 week
month.

The actual criteria is 3 or less days = 4 week month or 4 or more days
= 5
week month. Is it possible to put a formula in place to make this
automated.
Hope you can understand this explanation.

Thanking you in anticipation.
--
Big Rick