Calculate the beginning of the week

J

Jaz

I want to have a field in excel that gives me the "week of" date.

For example, today is 4/25/06.

The field would show the "week of" 4/23/06 because that is the date of last
Sunday.

I want it to automatically calculate the 'week of' data from today's date.

Is this possible? If so, how do I do it.

Thanks,
Jasper
 
N

Niek Otten

Hi Jasper,

=A1-WEEKDAY(A1)+1

--
Kind regards,

Niek Otten

|I want to have a field in excel that gives me the "week of" date.
|
| For example, today is 4/25/06.
|
| The field would show the "week of" 4/23/06 because that is the date of last
| Sunday.
|
| I want it to automatically calculate the 'week of' data from today's date.
|
| Is this possible? If so, how do I do it.
|
| Thanks,
| Jasper
|
|
 
Top