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.
|