Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Count Weekends

0

I would like to count the numbr of Saturdays and Sundays in a given year based on their work load.  I have figured out a formula for the number of events for any given year, but now would like to knwo how many weekends they are working, and if at all possible I would like to know if the weekends are sequencial...i.e. 3 weekns in a row.  

I have add the file that I am trying to work on...any help would be greatly appreciated.  

excel
posted by: pransford on Mon Feb 17, 2020 at 12:57 pm
Answer
Discuss

Discussion

You will either need to use helper columns, more or less with the formulas you already have, or VBA.
Variatus (rep: 4889) Feb 17, '20 at 11:06 pm
without VBA i will do 
beepetark Feb 18, '20 at 8:30 am
Thank you I look forward to any help...
pransford Feb 20, '20 at 9:46 am
You don't seem to need any help. You got all the formulas. They just need rearranging. Your datasheet design needs a revamp. Nobody can do it but you.
Variatus (rep: 4889) Feb 20, '20 at 7:28 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login