Another Working day question!
 

Hello,

I have two cells A1 and B1, in A1 I have a date. In B1 I want that date
5 working days later (Monday to Friday).

Is this possible in 1 formula?

Thank you for your time.

;)


--
neway9
------------------------------------------------------------------------
neway9's Profile: http://www.excelforum.com/member.php...o&userid=17622
View this thread: http://www.excelforum.com/showthread...hreadid=560174

Another Working day question!
 

Just add 5 in cell B1 (=a1+5) and drag the formula


--
blissworks
------------------------------------------------------------------------
blissworks's Profile: http://www.excelforum.com/member.php...o&userid=36156
View this thread: http://www.excelforum.com/showthread...hreadid=560174

Another Working day question!
 

Hello,

Yeah, got that, but need it to be working days only.


--
neway9
------------------------------------------------------------------------
neway9's Profile: http://www.excelforum.com/member.php...o&userid=17622
View this thread: http://www.excelforum.com/showthread...hreadid=560174

Another Working day question!
 

Hi neway9,

Will this work?

= WORKDAY(A1,4)


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=560174

Another Working day question!
 

Yeah, that works great,

Thank you!


--
neway9
------------------------------------------------------------------------
neway9's Profile: http://www.excelforum.com/member.php...o&userid=17622
View this thread: http://www.excelforum.com/showthread...hreadid=560174