Workday formula

Here's my formula at the moment: =(J2<TODAY()+5)

What I want : =(J2<TODAY()+5WORKDAY) - But this does not work???

I have a date in a cell when an application for payments must be made. I want a warning to appear 4-5 days before hand which I already have but I don't want weekends included in those 4-5 days.

If anyone can give me a formula that does this it would be very much appreciated!!!

Thank you

Possibly

=IF(J2<TODAY()+5,IF(WEEKDAY(INT(J2))<6,"Workday","Weekend"),"")

Not to sure what you want the result to be.

Originally Posted by Marcol

Possibly

=IF(J2<TODAY()+5,IF(WEEKDAY(INT(J2))<6,"Workday","Weekend"),"")

Not to sure what you want the result to be.

That didn't work but thanks anyway.

What I want the result to be: Say my deadline for a payment application is on wednesday (28/04/2010) I need a warning to pop up 4 days before hand but not including the weekend, so it would turn red today.

Originally Posted by DonkeyOte

Please stick to your original thread - you've been offered advice regards use of NETWORKDAYS - please utilise it.

http://www.excelforum.com/excel-prog...e-in-cell.html

That advice didn't help at all