Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I need help.
I have written a specific date, for eg 13/03/2013 in A1.
Now I want its corresponding weekday in A2 (i.e. 13/03/2013 (Wednesday).
In A3 I want it to show two days ahead (i.e. 15/03/2013).
If, however, the day in A2 is SUNDAY, then I want to add three days in A3. It should show 16/03/2013 (monday) in A3.

What functions/formulas should I use?

share|improve this question
    
Can you tell us what you've already tried? SuperUser is a place where we try to help those who themselves have tried to resolve something, but get stuck or run into a problem. You improve your chances of getting a response if you provide details of what you've already tried. This does two things; 1) lets us know you are willing to put in an effort and not expect someone else to just do it for you, and 2) helps us to not suggest what you've already tried. –  CharlieRB Mar 18 '13 at 11:57
add comment

1 Answer

In A2

=text(A1,"dddd")

Or just use =A1 and format with custom format dddd.

In A3

=if(weekday(a1)=1,A1+3,A1+2)

If you want to show the date, format with your preferred date format. If you want to show the weekday, format with custom format dddd.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.