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,
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,