Hello Friends
Please find the attached 2010 Version Excel file <Week number.xlsx>.
In Column A list of dates in text format `YYYYMMDD' available and in Column B values are plotted.
Now i want to calculate the average value (in Yellow cells) for the given week number (Week starts from Monday to Saturday)
1) With irrespective of any year,
2) with given year,
thanks in advance
thilag
Bookmarks