Transform week num on the first day/month of the week

[riadorra]

Hi,

Can anyone help me with the formala to to transform weeknum to the forst day of the week (dd/mmm).

obs: my week starts on Monday

\

Exemple:

day: 23/oct/2017 = week 43 = 23/oct 

day: 24/oct/2017 = week 43 = 23/oct 

day: 25/oct/2017 = week 43 = 23/oct 

day: 26/oct/2017 = week 43 = 23/oct 

day: 27/oct/2017 = week 43 = 23/oct 

day: 28/oct/2017 = week 43 = 23/oct 

day: 29/oct/2017 = week 43 = 23/oct 

day: 30/oct/2017 = week 43 = 30/oct 

day: 31/oct/2017 = week 43 = 30/oct 

day: 01/novt/2017 = week 43 = 30/oct 

thank you

Rid

[Phil_Seamark · Accepted solution]

Hi @riadorra

Please try this as a calculated column.  Just rename [Date] to the name of your column

Column = [Date] - WEEKDAY([Date],3)

[Phil_Seamark · Accepted solution]

Hi @riadorra

Please try this as a calculated column.  Just rename [Date] to the name of your column

Column = [Date] - WEEKDAY([Date],3)

[riadorra · Accepted solution]

Thank you Phil!