Greetings fellow young people.
I have a list of dates in excel that shows the current month's weekdays. I would like the list to auto-update based on month I list as the header of the list. is there a formula to do that?
i'm thinking of a EOMONTH and WORKDAY combo nested inside an IFS statement but not sure how to structure. basically I want it to show the workdays of the current month in the header and if it goes beyond that the cells are blank.
thoughts?
I have a list of dates in excel that shows the current month's weekdays. I would like the list to auto-update based on month I list as the header of the list. is there a formula to do that?
i'm thinking of a EOMONTH and WORKDAY combo nested inside an IFS statement but not sure how to structure. basically I want it to show the workdays of the current month in the header and if it goes beyond that the cells are blank.
thoughts?