Reference Cell question

[azamu]

Hello everyone,

in A1 I have the date and in B1 I have =A1 with a custom format "dddd" to show the day of the date. if I use a formula that reference B1 I get a zero result, but if I manually type in the day in B1 I get a result. How can I use the formula to use the value of B1 as reference?

Thanks,

 

[Scott R]

Sounds like you need the formula in B1 to be =DAY(A1).

edit: Sorry, that was for the number. To get text use =TEXT(A1,"dddd")

 

[jtakw]

Hi,

In line with Scott, or the formula you're using to reference B1, DAY(B1)

 

[azamu]

Hello thanks for the quick response.

This is kind of what I have. I tried using the Day(B1) but still got no result. In Column B8 the formula is =SumIF(A2:A4,A8,D2:d4) I also switched out the A8 to "Sunday" and still no result. but If I type in Sunday in A2 then I get 25

	A	B	D	E	F
1			RES	COM	RO
2	Sunday	4/1/2018	25	30	20
3	Monday	4/2/2018	26	60	40
4	Tuesday	4/3/2018	27	90	60
5
7
8	Sunday	0
9	Monday	0
10	Tuesday	0
11	Wednesday	0
12	Thursday	0
13	Friday	0
15	Saturday	0

<tbody>
</tbody><colgroup><col><col><col><col span="3"></colgroup>

 

[azamu]

Sorry didnt see your Edit, that work!! Thank you very much.