•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
WORKDAY Formula showing weekends
Hi! I am VERY new to excel, and learning formulas. I am creating a dynamic calendar (attendance purposes). I was following a video explaining how to create a dynamic calendar with a formula that should be excluding weekends.
However, when I enter the formula, some months (first image) ARE showing weekends, other months aren't (second image). Does anyone have any tips on what to do differently or what I am doing wrong?
This is the formula I am working with:
=WORKDAY(WORKDAY(EOMONTH(A3,-1),1),SEQUENCE(,NETWORKDAYS(A3,EOMONTH(A3,0)),0))
[link] [comments]
Want to read more?
Check out the full article on the original site