Get next working day

S

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
 
M

Mike H

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

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
Click to expand...

Try =WORKDAY(A1,1)

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

Chris Bode via OfficeKB.com

Suppose there is current date in A1 then to insert following Monday’s date
based on current date, follow following steps
1.Select cell B1 > right click > formate cells > number tab>select date from
category list > select 03/14/01 from type list
2.Now insert following formula in cell B1
=DATE(YEAR(A1),MONTH(A1),DAY(A1)+IF(WEEKDAY(A1)=1,1,IF(WEEKDAY(A1)=2,0,IF
(WEEKDAY(A1)=3,6,IF(WEEKDAY(A1)=4,5,IF(WEEKDAY(A1)=5,4,IF(WEEKDAY(A1)=6,3)))))
))

Now you get it !


Have a nice day



Chris
 
O

oldchippy

Mike said:
the OP only wanted Monday if the date was a sat or sun not next monda
in all
instances
Click to expand...
Sorry about that - my first post here, I was to keen to get started ;
 
Top