date problem

[mateofeo]

hi everyone
Looking for a formula to satisfy the following:

4 working days from my date field DateRecieved. That is, cell B2 would have a formula that referred to A2(DateRecieved) and the result would be DateRecieved + 4 workdays.

Thanks for any help!

 

[mhartman]

Hello
Place the below code in B2

=A2+4
'
Regards
Mark

 

[mateofeo]

thanks for the quick reply Mark, but that doesnt work. If I put +4 and the date is 08/01/06 in the DateRecieved(A2) cell, I get 08/05/06 which is a Saturday.. I need 4 workdays, weekdays, whatever (minus Saturdays and Sundays).

 

[pbaldy]

Since you specified workdays, see if the WorkDay function serves your needs.

 

[mateofeo]

Hi Paul.
can you explain how i would use it, i just cant seem to get this

Thanks

 

[pbaldy]

Did you look in Excel Help? What don't you understand about what it tells you?

 

[mateofeo]

I guess a good kick in the a@# works, i just figured it out.. Thanks~