WashingtonDC74
New Member
- Joined
- May 29, 2020
- Messages
- 4
- Office Version
- 365
- 2019
- Platform
- Windows
- MacOS
Hi,
I'm facing to an issue.
Indeed, I would like to find the weeknumber rounds up a date.
I have 2 columns which represent each starting date/ending date of one week.
For instance, I would like to find as output "2020/03" as of this input "17-1-2020 (January 17th, 2020)
I tried all of lookup formula (XLOOKUP,VLOOKUP,HLOOKUP,INDEX,MATCH) but no successful
I looking forward your ideas regarding my topic!
BR
I'm facing to an issue.
Indeed, I would like to find the weeknumber rounds up a date.
I have 2 columns which represent each starting date/ending date of one week.
For instance, I would like to find as output "2020/03" as of this input "17-1-2020 (January 17th, 2020)
I tried all of lookup formula (XLOOKUP,VLOOKUP,HLOOKUP,INDEX,MATCH) but no successful
I looking forward your ideas regarding my topic!
BR