Thread
:
How to compute date of next weekday?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ron Rosenfeld
external usenet poster
Posts: 5,651
How to compute date of next weekday?
On Wed, 30 Jul 2008 16:04:12 -0700 (PDT),
wrote:
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.
If you have the Analysis Tool Pak installed, you can use:
=WORKDAY(A1,1)
For instructions on how to install the ATP, see HELP for the WORKDAY function.
--ron
Reply With Quote
Ron Rosenfeld
View Public Profile
Find all posts by Ron Rosenfeld