Forum Discussion

jc4584's avatar
jc4584
Copper Contributor
May 27, 2024

Coping dates sequentially

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

and so, on, thanks

  • dscheikey's avatar
    dscheikey
    Bronze Contributor

    jc4584 

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

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

     Good luck!

Resources