I have a column in a dataset filled with dates, and I'd like to replace them with week values. Is there a way to set a specific span of dates (January 1, 2016 to January 7th, 2016, for example) and each time any date within that range appears to replace it with another value (Week 1, for example). Thank you for any help!
Below is the dataset I'm working on:
Text Date
Text 1 2016-02-05 10:55:00
Text 2 2016-02-09 10:56:28
Text 3 2016-02-18 20:40:33
Desired output:
Text Date
Text 1 Week 1
Text 2 Week 2
Text 3 Week 3