Is there a way to get day name (Mon, Tue, Wed, etc.) based on the value of another cell?
I have a spreadsheet for projecting work status. I populate a cell, for example "F3" called "Start Date", and then I display the name of the day of the week in another cell using "=TEXT(F3,"ddd").
I then want to place the name of the day of the week in the remaining cells in the row. I did it, rather clumsily, by putting the same formula in those cells and incrementing by a value of one, id est - =TEXT(F3+1,"ddd"), =TEXT(F3+2,"ddd"), and so on out to a value of +31, as that is presently the number of days addressed.
I'm am looking for a more elegant way to accomplish the task. Any suggestions appreciated.
Respectfully,
Fergie