Hi ExcelForum,

I need help on how to display week dates base given date (it can be the current system date).

Basically, from the given date, it will generate the week dates (from Monday to Friday) that the given date belonged to.

Sample: If given date is 22-Sept-08, output will be:
22-Sept-08 (Monday)
23-Sept-08 (Tuesday)
24-Sept-08 (Wednesday)
25-Sept-08 (Thursday)
26-Sept-08 (Monday)

Another sample: Given date is 25-Sept-08, output will be:
22-Sept-08 (Monday)
23-Sept-08 (Tuesday)
24-Sept-08 (Wednesday)
25-Sept-08 (Thursday)
26-Sept-08 (Monday)

I hope you guys can help me.

I use Excel 2003.

Thanks,