PDA

View Full Version : [SOLVED] formulas business days (automatic list)



elsg
05-02-2014, 09:28 AM
I need a formula to drag it to the right (after using the formula today in D2).


show me all working days, must discard (Saturday, Sunday and holidays)

Bob Phillips
05-02-2014, 11:17 AM
Try this

=WORKDAY(D2,1,$G$6:$G$16)

elsg
05-02-2014, 11:37 AM
Brilhant!!

thank you very much!!!