Somewhere in the workbook, enter a list of weekdays, starting with
Sunday (cells E1:E7 in this example)
In cell B1, enter the formula:

=TEXT(MATCH(A1,$E$1:$E$7,0)+5,"ddd")


LB79 wrote:
Hello - im having trouble trying to do something.
I have a worksheet and in cell A1 i type Sunday. I want cell B1 to add
five days on and return the day name.

Is there a way to do this?

Thanks




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html