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
|