Working Out Tax Weeks

[randy remark]

Hi,

I want a simple formula for working out the tax week from a given date ie 16/08/2002 is tax week 19.

Is there a way of doing this remembering that 53 can be used if the date is the first week of the following year.

Many Thanks

[LiveOak]

Pardon my ignorance, by what is the definition of a tax week? If this a calendar year event or a fiscal year event (sounds like the latter)? If the date is in the first week of the next tax year, why is it week 53 instead of 1?

-bd

[CobaltSky]

I suspect that the formula you're looking for is along the lines of:

WeekofYearFiscal(TextToDate(GivenDate), 2) - 14

---

where 'GivenDate' is the field with the date in it that you want to convert to tax year week no, and given that the tax year starts in week 14 on a Monday (day 2 of the week).