| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
week update
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.programming
|
|||
|
|||
|
week update
Try this in that cell
=IF(WEEKDAY(TODAY(),2)=1,TODAY(),TODAY()-WEEKDAY(TODAY(),2)+1) -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "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.programming
|
|||
|
|||
|
week update
perfect is there a way to do this to show the following weeks date as
well? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| week update formula | Excel Worksheet Functions | |||
| 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 | |||
Hybrid Mode
