View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Infinitogool Infinitogool is offline
external usenet poster
 
Posts: 52
Default 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.