Workday formula

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.