Get next working day
 

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

Get next working day
 

Try,

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

Mike

"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

Get next working day
 

An alternative

=A1-WEEKDAY(A1,3)+7


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.thecodecage.com/forumz/member.php?userid=111
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57111

Get next working day
 

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

"oldchippy" wrote:


An alternative

=A1-WEEKDAY(A1,3)+7


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.thecodecage.com/forumz/member.php?userid=111
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57111

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

Get next working day
 

Suppose there is current date in A1 then to insert following Mondays date
based on current date, follow following steps
1.Select cell B1 right click formate cells number tabselect 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
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via http://www.officekb.com

Get next working day
 

Mike H;208154 Wrote:
the OP only wanted Monday if the date was a sat or sun not next monday
in all
instances

"oldchippy" wrote:


An alternative

=A1-WEEKDAY(A1,3)+7


--
oldchippy

------------------------------------------------------------------------
oldchippy's Profile: 'The Code Cage Forums - View Profile: oldchippy'
(http://www.thecodecage.com/forumz/member.php?userid=111)
View this thread: 'Get next working day - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=57111)


Sorry about that - my first post here, I was to keen to get started ;)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.thecodecage.com/forumz/member.php?userid=111
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57111