Retrieve multiple dates, from a week number?

[stonescar]

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.

[flummi]

In order to work with week numbers you would need the analysis pack of
MS Office.

The easiest way to implement what you want ot do seems to be that you
put in A1 of your "week" sheet the date of the first day of that week.
On each of your "day" sheets you could have a simple formula that
refers to that day plus 0, 1, 2 etc depending upon what day you are on
like in =Sheet1!A1+1 for Tuesday, if your week starts on Monday.

Hans

stonescar schrieb:

> 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