View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Get next working day

On Sat, 31 Jan 2009 13:42:49 -0800 (PST), Savio wrote:

How can i write a formula to enter the following Monday's date if the
current day is a saturday or a sunday? It would be preferable to get
this in one formula
Thanks


Try =WORKDAY(A1,1)

If you get a #NAME! error, see HELP for the function for how to resolve.
--ron