I have the formula =text(weekday(date(calendaryear,1,2),1),”aaa”)
Automatically updates the weekdays in the row according to the year entered in a different cell.
But I also want to automatically update the weekdays in that same row according to the month entered in a different cell(b4). How should I change it my current formula
Solved by O. F. in 18 mins