Hello again,
I'm using excel 2003 and I searching for a small code to automaticly generate the begin- and end-date of a week (from monday till sunday)
the only variable that I wanna give is the Weeknumber.
So if I write a weeknumber in cell(a,1)
I want the begin-date (monday) in cell (b,1) and
I want the end-date (sunday) in cell (c,1).
for example:
A B C
1 36
2 04-09-2006
3 10-09-2006
4
can anybody help me with this??