Coping dates sequentially

Copper Contributor

I need to copy adjacent cells with day and corresponding num of the week sequentially ignoring year, example Monday 4

and so, on, thanks

1 Reply

@jc4584 

If your date is in cell A1, this function should give you the desired result.

=TEXT(A1,"DDDD")&" "&WEEKDAY(A1)

 Good luck!