I'm really new to excel and this forum, so please bear with me...

What I'm looking to do, is having one "week-sheet" and one sheet for
every workday, and having each of them updated with their correspondent
dates.

I.e. when I update/clear the excel file, to start a new week, I would
like each of the "day-sheets" to have a cell with their relevant date.


Ex
I update the file:
1) Cell A1 in "Week" retrieves the right week number.
2) Cell A1 in "Monday" retrieves the date for Monday in the current
week
3) Cell A1 in "Tuesday" retrieves...
etc.

(If possible I would like this operation to disregard the actual day of
the update (TODAY) so that I could update the file on a wednesday, and
still have the right dates for each day)

Is this possible? Do I need expansions? How?

Thanks in advance.


--
stonescar
------------------------------------------------------------------------
stonescar's Profile: http://www.excelforum.com/member.php...o&userid=36048
View this thread: http://www.excelforum.com/showthread...hreadid=558393