ExcelBanter - week update formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - week update formula (https://www.excelbanter.com/excel-worksheet-functions/221834-week-update-formula.html)

Savio

week update formula

is there any way to have a cell in excel update itself every week to
show the first day of the week?
say the week starts on a monday, the cell displays 23/02/09, retains
this value thoughout the week and displays 02/03/09 the following
monday
thanks

David Biddulph[_2_]

week update formula

=TODAY()-WEEKDAY(TODAY(),3)
--
David Biddulph

Savio wrote:
is there any way to have a cell in excel update itself every week to
show the first day of the week?
say the week starts on a monday, the cell displays 23/02/09, retains
this value thoughout the week and displays 02/03/09 the following
monday
thanks

Savio

week update formula

thanks thats perfect. is there any way to do the same only thing this
time to display the coming week?

David Biddulph[_2_]

week update formula

Add 7.
--
David Biddulph

Savio wrote:
thanks thats perfect. is there any way to do the same only thing this
time to display the coming week?

All times are GMT +1. The time now is 11:12 AM.