•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need Tips Creating a Custom Table
Essentially, I need help creating a table in Excel that allows me to calculate the number of program hours between two dates.
I work for a treatment program that offers 5 hours of group Monday-Thursday and 3 hours of group on Friday. What I'm trying to create is a table that will tell me the total number of group hours between two dates, ideally using drop down menus.
I've really gotten into the weeds, trying different functions and pivot tables, but I still haven't cracked it. Any help would greatly appreciated. Thanks!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel
#custom table
#program hours
#group hours
#drop down menus
#calculate
#between two dates
#functions
#pivot tables
#treatment program
#Monday-Thursday
#Friday
#total number
#help
#weeds