transform the date

[0li5a3a]

Hi,

is possible to transform the date format from

42107 TO  WW-YYYY?

I don't want to create a master calendar I want to do this just for a specific column in my table.

Thanks

[prat1507]

Maybe this

=date(42107 ,'WW-YYYY')

[0li5a3a]

I tried already this and doesn't work in my scenario...

the date looks like 01-2017, 02-2017, 03-2017 and again 01-2017, 02-2017, 03-2017 which is wrong suppose to be

01-2017, 02-2017,03-2017, 04-2017 to 52-2017

[antoniotiman · Accepted solution]

WeekName(Date) or

Week(Date)&'-'&Year(Date)

[prat1507]

Sorry

Use

=weekname(date(42094))

[tyagishaila]

=Week(date(42107 ))&'-'&Year(date(42107 ))

[0li5a3a]

using WeekName(Date)   i would have this format 2017- 23.

using Week(Date)&'-'&Year(Date)  i  would have this format 1-2017 ,12016, 2-2017,2-2016 I want to have this format ww-yyyy (52-2016,01-2017,02-2017................20-2017 etc)

[antoniotiman]

Num(Week(Date),'00')