Retrieve multiple dates, from a week number?

  • Thread starter Thread starter stonescar
  • Start date Start date
S

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.
 
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
 
Back
Top