EXCEL FORMULA to fill other cells

[ejeruratyuuga]

I have four columns in excel. Column A is named "Date" while Column B is named " Day".

Column C is designated for formula and is named "Formula".

Column B and C are to be hidden as soon as this problem is fixed (not a problem anymore).

Column D is named "Activities" and it SHOULD NOT contain the formula because I will type in there the activities I've done.

Column B, C, and D are the connected now to each other.

Column C will contain the formula that will fill Column D based on Column B.

Column D are editable cell meaning to say, I will type Data in some of the cell in Column D while other cell in Column D are automatically filled with "Saturday" and "Sunday" based on Column B using the formula in Column C.

Here's a scenario.

You will ONLY enter formula in Column C.
If B2 is "Sunday" or "Saturday" , then either "Sunday" or "Saturday" will be automatically copied in Column D.

And if Column B are Weekdays, I will type in the Data / Activities I've done in that day.

Is it possible? If so, what formula or Codes should I be using?

 

[Fluff]

Duplicate to: EXCEL FORMULA

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.