Holiday accrual formula when the holiday year doesn't start in Jan

[tharding]

Can anyone help? I've been asked to track holiday for my french colleagues. Their holiday year runs May-June

For a normal calendar year, I would use this formula =month(today ())*2.08 but can't think how I can show the accrual for this.

[Tbez]

Hi tharding.

Doese it help to make a conversion table to change month 1 to month 9 etc?

Make two columns, one that has 1,2,3,4.. The other starts with 9 and goes 9,10,11,12,1,2 ..
Use a Vlookup in your formula to get the french month number.

Regards

Tbez

[tharding]

thank you!

I'm useless at vlook up, can you help me with the actual formula so I can copy and paste please?

[Tbez]

Hi,

I dont exactly understand what you calculate in your formula, but i do know vlookup.

=VLOOKUP(month(today()),D:E,2,false)

This formula will give the French month. I dont have english excel, so maybe you use something other than : . Sorry if formula doesnt work. I attached an example in case it wont work.

So your formula was:
=month(today ())*2.08

Insert the vlookup and you get:
=VLOOKUP(month(today()),D:E,2,false)*2.08

I hope it works for u

[bebo021999]

Know nothing about holiday year, but to change month Jan to month May (4 month difference), use this:

Please Login or Register  to view this content.

no converted table required

[Tbez]

As you see tharding, Excel has many ways of getting to the correct answer. Bebo's answer was more efficient than mine - I learned something new.

I hope you figure it out. And also, I think everyone will benefit from learning vlookup. You'll like it =)

Good luck!