| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
following week
is there any way to have a cell in excel update itself every week to
show the first day of the following week? thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
following week
With a date in A1, the formula below will compute the date of the following
Monday =A1+(WEEKDAY(A1)1)*(9-WEEKDAY(A1))+(WEEKDAY(A1)=1) Remember to format as date Replacing A1 by TODAY() we get =TODAY()+(WEEKDAY(TODAY())1)*(9-WEEKDAY(TODAY()))+(WEEKDAY(TODAY())=1) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Savio" wrote in message ... is there any way to have a cell in excel update itself every week to show the first day of the following week? thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
following week
What day is the first day of the following week... Sunday or Monday? Also,
what do you want to show if the date IS the first day of the week... itself or the first day of the next week? -- Rick (MVP - Excel) "Savio" wrote in message ... is there any way to have a cell in excel update itself every week to show the first day of the following week? thanks |
| 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) | |||
| Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
| group sales by week and week number | Excel Discussion (Misc queries) | |||
| How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Linear Mode
