Display Week Dates based on a given Date

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,

Solved it:

Please Login or Register  to view this content.