calculate date but not sunday

i have date in a1..if in e1 i want a1+4 if result = sunday then a1+5..if result = sunday then a1+6 if result = sunday then a1+7 how to with formula

Try this:

Please Login or Register  to view this content.

what mean =1 beamernsw how
if not sunday and not saturday

You've changed your question. You originally asked "i have date in a1..if in e1 i want a1+4 if result = sunday then a1+5".

I don't understand your question now. How if result = sunday can it =A1+5 AND A1+6 AND A1+7??
Also you never mentioned anything about Saturday, before or now.

I think you need to think about the question and rephrase it better.

ok thankyou sir