Code To Add Date And Seven Day Week Number From Start Of Year

[Ingolf]

Read again post 7 from Admin.
Put this

range(daterange).cells(1)="ENTER DATE HERE"

in ClearDates

[rich_cirillo]

sorry my apologies...yes now wroks.Thank you

I`1m new to this so finally i need to use a button for these 2 operations..please how do i assign a button to achieve the result from my previous request in post #6

thank you

[rich_cirillo]

Please see attached file.....the week number is 53 and it skips week 1...can this be altered please?