Get next working day

[Savio]

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

 

[Mike H]

Try,

=A1+CHOOSE(WEEKDAY(A1),1,0,0,0,0,0,2)

Mike

 

[Mike H]

the OP only wanted Monday if the date was a sat or sun not next monday in all
instances

 

[Ron Rosenfeld]

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