UK Fiscal Week Formula

[Izaak-Brummitt]

Hi All,

Please could someone help me with a formula that gives dates a week number. I have two years worth of data and the week numbers have different start dates for each year. A week is a full 7 days.

i.e:

22/23 week 1 start: 04/04/2022

23/24 week 1 start: 06/04/2023

Thanks,

Izaak.

[Clifford_Coon]

Hi @Izaak-Brummitt ,  something like this should work:  CEIL(DateTimeDiff([Today],[Year_Start],"days")/7)