| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
show first weekday
How can I always display the upcoming Monday date?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show first weekday
try
=TODAY()+(9-WEEKDAY(TODAY())) -- Don Guillett SalesAid Software "MPI Planner" <MPI wrote in message ... How can I always display the upcoming Monday date? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show first weekday
What do you want it to show when the current day is a Monday, next Monday
or current date? If the former =TODAY()-WEEKDAY(TODAY(),2)+8 if the latter =TODAY()-WEEKDAY(TODAY()-2)+7 -- Regards, Peo Sjoblom "MPI Planner" <MPI wrote in message ... How can I always display the upcoming Monday date? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show first weekday
=TODAY()+6-MOD(WEEKDAY(TODAY())+4,7)
Note that if today is Monday, it shows today's date. If you want it to show next Monday if today is Monday, then try =TODAY()+7-MOD(WEEKDAY(TODAY())+5,7) -- David Biddulph "MPI Planner" <MPI wrote in message ... How can I always display the upcoming Monday date? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show first weekday
Yes, I thought my formulae looked more complicated than they needed to be.
:-( -- David Biddulph "Peo Sjoblom" wrote in message ... What do you want it to show when the current day is a Monday, next Monday or current date? If the former =TODAY()-WEEKDAY(TODAY(),2)+8 if the latter =TODAY()-WEEKDAY(TODAY()-2)+7 -- Regards, Peo Sjoblom "MPI Planner" <MPI wrote in message ... How can I always display the upcoming Monday date? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show first weekday
Hi,
Fails if today is a Sunday. Any formula with 9 as an offset will fail for one precise day during the week. Regards, Daniel M. "Don Guillett" wrote in message ... try =TODAY()+(9-WEEKDAY(TODAY())) -- Don Guillett SalesAid Software "MPI Planner" <MPI wrote in message ... How can I always display the upcoming Monday date? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show first weekday
Try:
=TODAY()-WEEKDAY(TODAY())+2 Kind regards, Erny "MPI Planner" <MPI schrieb im Newsbeitrag ... How can I always display the upcoming Monday date? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show first weekday
That won't show upcoming Monday, it will show the Monday of the current
week. For instance upcoming Monday for me for today (05/22/07) would be 05/28/07 but your formula returns 05/21/07. It might be that the OP wanted this but the word upcoming makes me think it is not the case -- Regards, Peo Sjoblom "Erny" wrote in message ... Try: =TODAY()-WEEKDAY(TODAY())+2 Kind regards, Erny "MPI Planner" <MPI schrieb im Newsbeitrag ... How can I always display the upcoming Monday date? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
| Weekday | Excel Worksheet Functions | |||
| show customer based on Weekday | Excel Worksheet Functions | |||
| Show Weekday with date??? | Excel Discussion (Misc queries) | |||
| WEEKDAY using IF | Excel Discussion (Misc queries) | |||
Linear Mode
