Year Week Number

[joshua1990]

I would like to add the Year Week Number into my calendar so I can differentiate between year cross overs.

I already have a column like:

Fiscal Year = 2019

Fiscal Week = 01

Since the column "Fiscal Week" I need some workaround to get a whole number for YearWeek.

But how?

How would you add a combination of the year and week number as a sequential column?

A multiplication or with FORMAT?

[AnkitKukreja · Accepted solution]

Hi @joshua1990 

I generally use 2019 * 100 + 1 that would give you 201901 ; 2019 * 100 + 2 = 201902 and so on.

I think this would help you achieve what you want to.

Thanks,

Ankit

[Anonymous]

@joshua1990 ,

I believe you already have a week number column.

Do you want to concatenate year and week?

Appreciate your kudos !! Mark this post as solution if this helps.