Link to home
Start Free TrialLog in
Avatar of Jagwarman
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
Avatar of Gašper Kamenšek
Gašper Kamenšek
Flag of Slovenia image

I'm not quite sure I understood the question correctly but I think you need
=Workday(TODAY(),1)
=Workday(TODAY(),3)
=Workday(TODAY(),5)
Those are your dates...
Hope this helps
Avatar of Jagwarman
Jagwarman

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
ASKER CERTIFIED SOLUTION
Avatar of Gašper Kamenšek
Gašper Kamenšek
Flag of Slovenia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
many thanks that's great