1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Trying to create a list that by change the start date in a cell will create all workdays for that month excluding weekends and preset holidays

I am working on for my job an excel productivity tracker i am trying to create a formula that will list all work days excluding holidays that i put in a cell range from the start date that i will from cell a1 by entering in m/dd/year but using workday(a1,sequence(30),b1:b5) errors out when i use it for September-December just shows #### for random week days throught the months and i dont know why can someone offer some advise

submitted by /u/djeddy21
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#AI formula generation techniques
#formula generator
#workdays
#Excel
#workday
#productivity tracker
#formula
#start date
#holidays
#cell range
#sequence
#weekends
#advise
#errors