Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to compute date of next weekday?
Suppose D3 contains some date (e.g. 7/11/2008).
What's the "best" way to compute the date of the next weekday (7/14/2008)? Currently, I am using the following array formula: =MIN( IF( WEEKDAY(D3+ROW($1:$3), 2) <= 5, D3+ROW($1:$3) ) ) It works fine. But is there a better formula? I would prefer a non-array formula. PS: I am using Excel 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to compute date of next weekday?
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to compute date of next weekday?
Hi curiousgeorge
=WORKDAY(d3) ??? Regards, Pedro J. Suppose D3 contains some date (e.g. 7/11/2008). What's the "best" way to compute the date of the next weekday (7/14/2008)? Currently, I am using the following array formula: =MIN( IF( WEEKDAY(D3+ROW($1:$3), 2) <= 5, D3+ROW($1:$3) ) ) It works fine. But is there a better formula? I would prefer a non-array formula. PS: I am using Excel 2003. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to compute date of next weekday?
On Jul 30, 4:32*pm, Ron Rosenfeld wrote:
=WORKDAY(A1,1) Klunk! I thought something like that existed. But when I didn't see it in the See Also list for WEEKDAY, I gave up. Sigh, I shoulda looked at the complete Data and Time Functions list. Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to compute date of next weekday?
On Wed, 30 Jul 2008 17:01:28 -0700 (PDT), wrote:
On Jul 30, 4:32*pm, Ron Rosenfeld wrote: =WORKDAY(A1,1) Klunk! I thought something like that existed. But when I didn't see it in the See Also list for WEEKDAY, I gave up. Sigh, I shoulda looked at the complete Data and Time Functions list. Thanks. Glad to help. Thanks for the feedback. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating weekday date | New Users to Excel | |||
convert weekday date to the next sunday date | Excel Worksheet Functions | |||
WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
MATCHING DATE TO A WEEKDAY | Excel Worksheet Functions | |||
Show Weekday with date??? | Excel Discussion (Misc queries) |