| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
week update formula
thanks thats perfect. is there any way to do the same only thing this
time to display the coming week? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
| Update all tabs, incrementing one week per tab | Excel Worksheet Functions | |||
| update week to week in excel. | Excel Worksheet Functions | |||
| update week to week in excel. | Excel Worksheet Functions | |||
| I need a payroll sheet that can auto update figures each week | Excel Worksheet Functions | |||
Linear Mode
