Thank you Shrivallabha, I had tried the challenge but I have not found the way to solve, even your code I have not seen before, it is ok how the problem has been solved, we find the date in column B and the number that is in cell of column A is shown next to the contracted date.
In reality these weeks correspond to working days, here the working days are from Monday to Friday, on Saturday and Sunday tourism plans are made.
On the other hand, suppose the case of growth control of animals, chickens, pigs, cattle, etc. the week in which these are born is week 1. Both the control of growth and the control of diseases is done in weeks of 7 days (Monday to Sunday), here if it is considered Saturday and Sunday
In the case of the production in a factory there, the weeks of the year are considered to establish the production lots and the concept of Chihiro would serve me
I thank you very much for the solution I hope that the other semas the label shows 9 because I do not want to now urgar in the configuration of the computer because I have automatic files.
Sorry if the translation is not so good
Thank you
Solved theme