MS Excel macro for not counting weekends? -

q: how can create macro (any ideas?) "overdue" column?

it should "y" if the:

created column+days column younger current date.

it should "n" if not.

but: weekends not needed counted..

so if ex.:

the "created" "8/10/2013 22:38" - saturday weekend , "days" 2, addition of 2 should be: 8/13/2013 24:00
if "created" "8/16/2013 11:26" - friday, weekday , "days" 2, addition of 2 should be: 8/20/2013 13:34

example:

today is: 8/13/2013 10:25  created     days    overdue 8/10/2013 22:38     2   y 8/12/2013 11:26     2   n

because:

8/10/2013 22:38 + 2 days younger 8/13/2013 10:25, "overdue" needs "y" 8/12/2013 11:26 + 2 days older 8/13/2013 10:25, "overdue" needs "n"

what using if , compare date now() ?

=if( (a2+b2)<now(),"y","n")

(okey, check updated question , make new inputs here...)

used formulas:

=weekday(b2)         =if(d2=7,1,if(or(d2=5,d2=6),2,0))    =b2+c2+f2    =if(g2<now(),"y","n")

something this?

Naan