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")