Hi Guys

I am using the following formula to calculate annual days leave based on an employees length of service. i.e. less than 5 years = 25, 5 to 10 years = 26, and over 10 years = 27 for Office based staff. Site based staff get an additional day for each period.

=IF(H2="Office",(IF(SUM(W$2:W$378<5),25,IF(SUM(W$2:W$378>=5)*(W$2:W$378<10),26,27))),IF(H2="Site",((IF(SUM(W$2:W$378<5),26,IF(SUM(W$2:W$378>=5)*(W$2:W$378<10),27,28))))))

However I would like to amend it to only give "Site" based staff this extra day if they started before 01/04/05. I have tried to add IF(SUM(M$2:M$378>AA$2) after ..H2="Site.. with column M being the start date and AA being 01/04/05. But I have an issue with my parenthesis as I keep getting FALSE where it does not equal Site.

Is there a better way to do this or easier just to try and fix this?

Thanks

Cortlyn