Separate week, month, year into columns from date

Copper Contributor

hi!

I would like to separate my date into weeks, months and years in separate columns, is there a function or code for this? Thank you.

 

Annotation 2020-04-05 093601.jpg

1 Reply

@jitterbug888 Perhaps like this? It will give you week number, month number and year.

Screenshot 2020-04-05 at 07.27.02.png