Search results

Thanks Mark! I played around with your code / comments for awhile and couldn't quite get what I needed (I'll spare you the details unless you really want them). However - I figured out exactly what I needed by essentially locking a "start date" (min of date data set) and then counting...

Thanks for your reply- I appreciate it. I think you might be missing my intent just a bit. I don't care about really care about weekdays, weekends year, etc and won't be comparing year to year. I don't believe the DateDiff function will work as it seems to be built off traditional calendar...

Hello all thanks for viewing. I have a calendar table that lists one row entry per date and it will be dynamic as I want to run queries down the road and "look back 1 year from today". What I would like to do is create my own week number based on the dates displayed. Simply I want to take the...

Hello Everyone! New member thought I would say hello. I live in Seattle, WA and have 10 years professional experience as an Industrial Engineer and Business Analyst. In my Analyst role I use Microsoft products daily for data analysis and while I gravitate towards Excel, I've been pushing...