Identifiers for fortnightly periods.

[farmerscott]

Hi,

Sorry for the vague title.....

This is part of a calendar I am developing in Excel but is used in PowerBi.

What I would like to know what naming conventions people have come up with to identify a fortnightly period, preferably using dates, rather than fortnight1, fortnight2, etc.

1/1/24 to 14/1/24 might be 1,14,1,24 but things get tricky when a new month starts within the period.

Thanks.

 

[dermie_72]

Fornights are just 2 weeks. There is a Weeknum function that identifies the week it's in. So personally, I would be using a roundup of the weeknum/2 to get the fortnight number.
you don't name your weeks 1,7 it's week1. Just my opinion is all.