This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello - I'm looking to group line items based off of range of dates. Specifically, I have one Date column (format '3/18/2019') and would like to create a new column with week values based off of specific ranges in the Date column. The new column's dimensions would follow:
I had a date in 2020 (2/1/2020) that was assigned a value of -4. The formula does not seem to take into account the year. Can you think of any workarounds to account for this? The value should be 50, rather than -4.