willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 893
- Office Version
- 365
- Platform
- Windows
Hello,
I need help with a formula that will give me a list of the ISO week numbers between 2 dates.
Thank you to anyone who can help!
Note: The 2 dates are linked cells from a combo box so they come through in that format - as a value, but my other formulas compensate for the format so I need the Week number formula to be able to do the same.
I need help with a formula that will give me a list of the ISO week numbers between 2 dates.
Customer Part Analysis Dashboard.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Todays date | 2021-03-18 | Week Number List | |||
2 | Year Selected | 2021 | 53 | |||
3 | Input Date Range | 44197 | 44227 | 1 | ||
4 | 2 | |||||
5 | 3 | |||||
6 | 4 | |||||
Graph Data |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | B1 | =TODAY() |
Thank you to anyone who can help!
Note: The 2 dates are linked cells from a combo box so they come through in that format - as a value, but my other formulas compensate for the format so I need the Week number formula to be able to do the same.