Hi Sunny, the formula's all work fine, thanks.

The only logical thing that won't work with the current formula's is if (for example), the staff member started on 08/01/2018 when the 'JAN' pay period began on 07/01/2018. They would need to be included in 'JAN' pay period but the formula doesn't allow this to happen. They are only inserted from 'FEB' onwards...?

It works all ok when a leave date is inserted and they are in the last pay period because of the way the dates/formula's work.

Can you think of a way around this because it's a vital part of the wages sheet I'm trying to design?

Andy

P.S I know we could just amend the start date to suit the formula but I want the start date to be accurate for future records.

Hi Andy

Try this.

If it is not working then give me some sample dates and which starting period you expect the staff's name to appear.

Sunny

Hi Sunny, that works perfectly! Thank you so much for your help!

Andy

Hi Andy

No problem.

Merry Christmas

Sunny

Hi Sunny, just got a formula I've been trying to create but haven't been quite able to do it. Are you able to help? See attached.

Thanks

Andy

Hi Andy

Give this a try

Hi Sunny/all, I'm looking for some help in the attached spreadsheet to calculate holiday entitlement for my employees. I'm looking to have this calculated based on start or end date for the 2021 calendar year. Are you able to help me?

Happy to take any questions.

Thanks

Andy

Hi, would someone be able to look at this request for me and help me with the formula for it?

Thanks

Andy

Hi Andy,

This looks like a new question and unrelated to the previous questions. Please raise a new topic.

Thanks,

Mynda