Join us June 17–18 for a deep dive into Copilot Control System—live expert-led sessions and Q&A on data security, agent lifecycle, adoption, and more! Learn more >
jem2433Copper ContributorJan 16, 2023How to convert Month and Year into day of the week ascending down for each new day.
1 ReplyReplies sorted by NewestSort ByMost LikedOldestNewestPatrick2788Silver ContributorJan 16, 2023jem2433 Try this:=TEXT(DATE(YEAR($B$5),MONTH($B$5),A9:A39),"dddd")
Patrick2788Silver ContributorJan 16, 2023jem2433 Try this:=TEXT(DATE(YEAR($B$5),MONTH($B$5),A9:A39),"dddd")