willow1985
Wellknown Member
 Joined
 Jul 24, 2019
 Messages
 718
 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  20210318  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.