EXCEL FORMULA

[ejeruratyuuga]

I have four columns in excel. Column A is Date while Column B is Day. Column B depends on the value in Column B and I got the Formula for any specific date for column B and that's not my concern anymore.
Column C is designated for formula.
Column B and C are to be hidden (not a problem).
Column D is Activities.
My concern is I want Column C to not contain any formula but I want it to be filled with values based on another column or cell.
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 in some of the cell in Column D while other cell in Column D are automatically filled based on Column B using the formula in Column C.
Here's a scenario.

You will 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 Activities I've done in that day.

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

 

[FMHasan]

New Microsoft Excel Worksheet.xlsx
	A	B	C	D	E
2	Date	Day	Formula	Activities
3	13-03-22	Sunday		Sunday
4	14-03-22	Monday
5	15-03-22	Tuesday
6	16-03-22	Wednesday
7	17-03-22	Thursday
8	18-03-22	Friday
9	19-03-22	Saturday		Saturday
Sheet2

Cell Formulas
Range	Formula
B3:B9	B3	=TEXT(A3,"dddd")
D3:D9	D3	=TEXT(IF(OR(TEXT(A3,"dddd")="Sunday",TEXT(A3,"dddd")="Saturday"),A3,""),"dddd")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D3:D9	Cell Value	contains "Saturday"	text	NO
D3:D9	Cell Value	contains "Sunday"	text	NO

 

[ejeruratyuuga]

Following your given solution, formulas in Column D (Activities) will be remove as soon as I input my activities in cells under column D.

I was actually looking for a formula in column C (Formula) that will fill up column D.

 

[Peter_SSs]

I was actually looking for a formula in column C (Formula) that will fill up column D.

In your version of excel, a formula can only populate the cell that it is in. So a formula in column C cannot put a value in column D

Your overall description is very confusing:

Example 1

Column B depends on the value in Column B

Example 2

Column C is designated for formula.

My concern is I want Column C to not contain any formula but I want ....

Column C will contain the formula that will fill ...

 

[ejeruratyuuga]

Oops. Sorry. My bad. I didn't notice I had my description wrong. Sorry for confusion it brought. ? I'll post another thread.

 

[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?