Jagwarman
asked on
formula to select today +1 today +3 and today +5 but
Is the a formula that I can use to select today +1 today +3 and today +5 but exclude weekends.
so today [1/8/2014 I would say if A2=Today select today +1 today +3 and today +5 "Yes" , "No" but exclude weekends.
so the dates I would expect to have Yes are 4/8, 6/8 and 8/8
Thanks in advance
so today [1/8/2014 I would say if A2=Today select today +1 today +3 and today +5 "Yes" , "No" but exclude weekends.
so the dates I would expect to have Yes are 4/8, 6/8 and 8/8
Thanks in advance
ASKER
I need to be able to put this in an IF statement to say IF A2 = .........."Yes","No"
would you know how I would do that?
Thanks
would you know how I would do that?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
many thanks that's great
=Workday(TODAY(),1)
=Workday(TODAY(),3)
=Workday(TODAY(),5)
Those are your dates...
Hope this helps