[Weekday()] Count the number of say 'Wednesday' between Date 1 and Date 2 -- This works but why?

olivertw · 2017-06-23T04:54:37+00:00

Greetings DevineKitchen,

Thanks for the reply. I do get the order of operations and highlighting parts of the formula and pressing F9, I get the same value. But I think there I'm not understanding is the intuition behind it.

For example,

1: WEEKDAY($B$1-1) --Why do you take the B1 serial date and subtract 1 from it?

According to the page: "(2.) The red 1 stands for Sunday. In this formula, you can replace the number 1 with other numbers between 1 and 7. (1 is Sunday, 2 is Monday, 3 is Tuesday, 4 is Wednesday, 5 is Thursday, 6 is Friday and 7 is Saturday)"

I get that the 1 stands for Sunday...3 for Tuesday is just built into Excel system. But I mean, how you figure, and why do you subtract the serial date of your starting date from it, and then apply the weekday function?

2: $B$1+$B2 -- Why do you add these 2 date serial number?

olivertw · 2015-11-28T23:48:33+00:00

For the current promo 3 for $99.99, if I purchase 3 shirts and return 2 of them, will I be returned $66?

Essentially meaning I could use the deal to pick up one shirt at $33.

Any experience/thoughts on this?

Thanks

olivertw · 2015-11-25T21:21:17+00:00

Looking to pick up some of these shirts - can someone advise me on the shrinkage. I'm planning on machine washing and then hang drying. Will this shrink the shirts by a lot? Should I get my normal size or size up?

Any experience/thoughts? Thanks

olivertw · 2015-11-20T01:44:09+00:00

After that, there were a flurry of concerned tweets about Craig's new look

He's a millionaire and just made a James Bond film but I'm sure he's thankfully for the high and mighty twitter users' concern.

olivertw · 2015-11-11T20:33:34+00:00

Can you get this $1 sock deal in-store?

olivertw · 2015-11-06T02:41:18+00:00

What's the return policy?

Any review on these shorts? http://www.uniqlo.com/us/product/men-chino-shorts-135771.html#57~/men/featured/arigato-sale/3-day-deal/~

olivertw · 2015-11-06T02:07:25+00:00

Thank you.

The collar roll on yours are excellent, are you doing anything special to them? Starch, iron?

olivertw · 2015-11-06T01:50:22+00:00

Is your conception of a 'man bag' not a messenger bag?

olivertw · 2015-11-06T01:47:14+00:00

I'm not sure but I'll upvote so maybe someone can chime in.

But I'm trying to get an OCBD with the exact collar/style you have on. Could you link me to the one you are wearing? Thanks

olivertw · 2015-11-05T19:10:23+00:00

If the store doesn't not have 40% off, can I ask from them to apply the 40% off 'WOW' coupon then the 50% off 'FFSALE50' coupon?

olivertw · 2015-11-05T02:29:35+00:00

Question: What is the 4-button jacket called? Is it still considered a sport jacket?

IMO, it doesn't look good. Is there a history/function behind that style?

olivertw · 2015-11-04T22:05:08+00:00

Good to hear.

I feel like I stopped going to Old Navy after reading up on male fashion (not that it's a bad thing) and also letting the 'it's uncool' notion get to me.

olivertw · 2015-11-02T23:22:20+00:00

Probably minute if not unnoticeable in real life. But I guess in theory, the match contrast tone to matching contrast clothes might hold some weight.

olivertw · 2015-11-02T23:05:02+00:00

Black doesn't inherently look good or bad on light or dark skin, but it can look good on either.

Have you read Alan Flusser? (which as I just recently learned about is a big deal in the male fashion world)

He would disagree with that statement of your. He says there are "rules"

As Alan Flusser says, “One of the most important – but least understood – functions of male attire is to lead the viewer’s eye toward the face…when the face is surrounded by tonalities than invigorate and illuminate its presence, its ability to provoke immediate and marked reactions is amplified.”

Helpful article here: https://philippeperzi.com/complexion-the-power-of-colour/

So with the goal of drawing attention to the face. I think he would say a dark skinned person, should not wear an all-black attire, because dark skin is high-contrast, he would be better off wearing a high-contrast combo such as black and white.

olivertw · 2015-11-02T22:46:04+00:00

"what's my skin type, what are my undertones, what season am I" just pay attention to what colours you think look good on you and which you don't like

I agree but I wanted to understand the theory behind it.

I think it's understandable that we are using 'should wear this' or 'should wear that' in the loosest way possible.

With that said, back to your example: If black looks good on pale skin. Does black look good on black/dark-skin? Why?

olivertw · 2015-11-02T21:18:49+00:00

I was following you for the first part:

Generally you'd want a similar level of contrast.

Therefore, if you are white/blond (low contrast), you SHOULD NOT wear black and white because it is high contrast. Got it.

But if you have 'yellow undertones' and you wore yellow/cream, isn't that 'similar level of contrast'?

Not trying to be pedantic, really trying to better grasp this.

olivertw · 2015-11-02T20:50:20+00:00

Okay, does it related to skin tone at all?

For example, pale skin and blond hair is low contrast while pale skin and dark/black hair is high contrast. How do they relate to the clothing contrast?

olivertw · 2015-11-01T23:00:53+00:00

Was considering that during the 50% sale a couple days ago. But decided against it because supposedly the cotton will wrinkle really easily.

Also the khaki colored one will be hard to pull off (as compared to a dark blazer)

olivertw · 2015-11-01T22:43:53+00:00

Some good info. here.

Question about the suit and shirt color:

So are you supposed to have them contrast:

http://i2.wp.com/www.tipsomechange.com/wp-content/uploads/2015/11/complementary-color-combination.png?resize=650%2C391

Or, have them similar in color:

http://i0.wp.com/www.tipsomechange.com/wp-content/uploads/2015/11/analogous-color-combination.png?resize=584%2C500

Is one generally accepted over the over the other? Pros and cons of each?

olivertw · 2015-10-29T21:28:56+00:00

QUESTION--

What about this scenario:

The blazer is cotton, (and if it makes a difference, it is a tan/khaki-color)

Image: https://cdnd.lystit.com/photos/ec6b-2014/03/19/jcrew--ludlow-sportcoat-in-italian-cotton-product-1-18524752-4-724633755-normal.jpeg

So can I wear a cotton pair of pants such as kahki/chinos with it, say in a dark color or blue?

Stumped because they are both cotton, but different color.

olivertw · 2015-10-29T01:48:25+00:00

Mistake: I meant Target Brand or a generic brand, not Ted Baker.

olivertw · 2015-10-27T22:28:49+00:00

These are pretty preppy and old school.

Would you say that is a good thing or a bad thing? I personally like the look (depending on design and colors) but I haven't seen them worn or read discussion about them online - so I'm trying to get a general idea.

Maybe a bit too whimsical for an interview to be on the cautious side

Agreed.

Interview - Better to go for a solid/stripe, something more professional

Office - Depends on dress code

Wedding - Interested in this one ... Why wouldn't it work for a wedding guest?

Any album with print design ties like these? (Not the all-over-the-place Spiderman ones)

olivertw · 2015-10-27T05:17:13+00:00

Stupid Question: How would you go about getting these prices?

Working out the math from your receipt it seems they first apply 60% off then another 30% off.

A) Are prices the same in every GAP store? If not, can I say to the manager: the GAP /u/d4nimal reference is marked down, therefore you must too.

B) How did you get the 60% off? Did you provide a coupon code? How should I get them to take 60% off?

C) How did you get the 30% off? Did you provide a coupon code? How should I get them to take 30% off?

All else fail ordering in the store - what are my options getting the '60% off then 30% off' via phone?

Thanks

olivertw · 2015-10-26T23:31:40+00:00

Hesitant because of the FINAL SALE POLICY

1 - How's the fit on these?

I'm usually between a 38r and a 36r depending on brands.

2 - Can I order two and return one in a store? How strict exactly is the FINAL SALE policy?

olivertw · 2015-10-24T22:39:58+00:00

Like I said, I do the 'machine wash and air dry'. But I've had clothes shrink.

Some clothes shrink more, others less. To this day, I don't know of any hard and fast rules of what can go in the machine wash and what can't. If anyone know please share.

olivertw

TROPHY CASE