Help A Sistah Out!!! - Formatting Cell --> Day of Week

[Fa.Fa]

SHORT VERSION:
I have a column for date of draft depending on date of load. I want to be able to have the DRAFT date automatically filed after entering the date

LONG VERSION:

So I started helping out at a fuel company and I was bragging about being good at excel. I didn't know nearly as much as I thought I did! They asked me to do what i thought was a simple task and i'm STUCK!

1. record fuel purchased
2. record fuel sold
keep track of how much is used
=SUM(D6,E7,-F7)- that's the formula i came up w/ that seems to work fine.

But the next part is what is giving me problems.
i was asked to also record a drafting schedule -
EX.
Loads pulled on Tuesday and Wednesday of the prior week will be drafted on Monday
Loads pulled on Thursday, Friday, and Saturday of the prior week will be drafted on Wednesday.
Loads pulled on Sunday and Monday will be drafted on Friday.

I wanted to somehow use the date to automatically give the draft day. and if that wasn't possible i delegated 1-7 to Mon - Sun respectfully. I tried to format cell so they would change the load day of 1 to Monday and in another column under draft day to 5 - Friday for a fuel load on monday to be drafted on friday.

Please help me out as much as you can't. I couldn't find it on google or youtube. i probably don't know what exactly to look for.

thanks in advance.

 

[West Man]

A shorter formula giving the same result as that:

=LOOKUP(WEEKDAY(A1),{1,3,5},{"Friday","Monday","Wednesday"})

Shorter and better. Consecutive Fridays, Mondays and Wednesdays in my formula should have made me think of hard coded arrays and lookup. That's why you are a MVP and I am not.

 

[Fa.Fa]

Thanks so much guys. I love this forum! So many different ways to do one thang! Everythings been working smootly.

I even changed the format to NOT include the weekeday so its just 10/13/11 - and i'm just amazed that the formula still was able to give me the right draft date w/o the weekday spelled out in the Load Date column!

While we're at it. Instead of using the weekday - Monday, Wednesday or Friday - is there a way to have it put the Whole dayt monday, mm,dd,yyyy...

 

[West Man]

Try: =A1+CHOOSE(WEEKDAY(A1),5,4,6,5,6,5,4) and format as desired.

 

[Fa.Fa]

That did the trick! Ahh, after fooling around with the worksheet I guess I'm learning the right questions to ask! You've all been very helping. Thanks again.

 

[West Man]

Good to hear it worked for you and happy to have been of assistance.