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 |