List of ISO week numbers between 2 dates

[willow1985]

Hello,

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.

 

[willow1985]

Thank you for your help. I will wait to see if anyone has the answer to the new thread.

Thank you again for the ISOWEEKNUM formula, it is much appreciated.

 

[willow1985]

For anyone in the future reading this, I figured it out.

I made this line affect the linked cell:

ActiveSheet.Date_End.Value = Format(ActiveSheet.Date_End.Value, "mmmm d,yyyy")

And this line affect seperate cells that referenced the linked cell:
Range("c3") = CDate(Me.Date_End)

It worked beautifully.

 

[Fluff]

Glad you sorted it & thanks for the feedback.

 

[willow1985]

Sometimes this line doesn't always work, not sure why but reselecting the date again seems to give it a kick. Something I will look into anyway.

ActiveSheet.Date_End.Value = Format(ActiveSheet.Date_End.Value, "mmmm d,yyyy")

Thanks again for your help.

 

[Fluff]

My pleasure.