kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 922
- Office Version
- 365
Hi,
I have the following table:
I have the dates in the first column. In the second column, I am trying to name the week based on the date. For example 3/1/2022 is Jan Week 1.
Is it possible to do this with a formula ? Appreciate all the help.
I have the following table:
Date | Week |
3/1/2022 | Jan Week 1 |
12/1/2022 | Jan Week 2 |
5/2/2022 | Feb Week 1 |
4/3/2022 | Mar Week 1 |
I have the dates in the first column. In the second column, I am trying to name the week based on the date. For example 3/1/2022 is Jan Week 1.
Is it possible to do this with a formula ? Appreciate all the help.