•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
Tagged with
#AI formula generation techniques
#formula generator
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#rows.com
#machine learning in spreadsheet applications
#WORKDAY
#formula
#weekends
#Excel
#dynamic calendar
#attendance
#EOMONTH
#SEQUENCE
#NETWORKDAYS
#tips
#dynamic calendar formula
#Excel formulas