Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 30, 2024 08:11 AM
I am trying to sort by the Week # of the year that an entry is assigned on my base. Its sorted by year, then by week - so 2024, week 1 through 52, etc.
However, for anything this week up until the 31st, its showing up as the 1st week of Dec 2024 (which confuses me as you would think it'd be 1st week of 2025?). I would like that to show up as the last week of Dec 2024 (week 52) or even Week 1 2025.
Formula is:
WEEKNUM((Assigned), "Monday")
It is pulling data from the "Assigned" column, which is listed in the format: 12/30/24 11:00am
Thanks!
Solved! Go to Solution.
10 Replies 10
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 04, 2025 04:14 PM
Thank you! I'll take the week 53 to keep it in 2024. Thank you all!

- « Previous
-
- 1
- 2
- Next »