Thanks for your fast reply.
i created a veriable named “year”. i used
but it is only giving me the current year.
and also i’ve used
CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(new DateTime(2019, 12, 02) , currentCulture.DateTimeFormat.CalendarWeekRule, currentCulture.DateTimeFormat.FirstDayOfweek)
which is giving me the correct year but i don’t wants to mentioned the date.
without mentioning the date and it should take the data from excel file. and it should print only year.