Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
jc4584Copper ContributorMay 27, 2024Coping 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
dscheikeyBronze ContributorMay 27, 2024jc4584 If your date is in cell A1, this function should give you the desired result.=TEXT(A1,"DDDD")&" "&WEEKDAY(A1) Good luck!
