L Laura Pankey New Member Mar 4, 2016 #1 I would like to have B3 be Mon, Tue, etc., based on the date that is in A3. What exactly do I have to put in B3 to have that occur?
I would like to have B3 be Mon, Tue, etc., based on the date that is in A3. What exactly do I have to put in B3 to have that occur?
V vletm Excel Ninja Mar 4, 2016 #2 @Laura Pankey for B3 ... =TEXT(A3,"ddd") or You could format A-column like 'ddd dd/mm/yyyy' => Sun 02/02/2016
@Laura Pankey for B3 ... =TEXT(A3,"ddd") or You could format A-column like 'ddd dd/mm/yyyy' => Sun 02/02/2016
L Laura Pankey New Member Mar 9, 2016 #3 Thanks! I really appreciate it. I also found another way. In B3 I put... =A3 and then formatted the cells to be ddd. Seems to work. But I'm also going to try what you suggested.
Thanks! I really appreciate it. I also found another way. In B3 I put... =A3 and then formatted the cells to be ddd. Seems to work. But I'm also going to try what you suggested.
