ongengthai1973
Board Regular
- Joined
- May 6, 2019
- Messages
- 55
I am facing problem on week number for year 2022. Need you guys to solve.
I use formula : =WEEKNUM(I4) and Excel show 1
If I use formula : = WEEKNUM(D5) and Excel show 2
Question : Is there any formula to calculate 1/03/22 to 1/08/22 show week#1? instead of week#2.
Thank you,
ET.Ong
I use formula : =WEEKNUM(I4) and Excel show 1
If I use formula : = WEEKNUM(D5) and Excel show 2
Question : Is there any formula to calculate 1/03/22 to 1/08/22 show week#1? instead of week#2.
Thank you,
ET.Ong