Distributing 6 Working Days Across Months

[FarmAccountant]

I have 2 column headings for a beg and end date. I have 12 column headings for all 12 months. I need to type in the beg/end date and then have excel put in the # of working days (6 INCLUDING Saturday) in the related months. I've been able to use one for 5 days, but I NEED 6. Any help would get GREAT! Thanks. Using Excel 2010

 

[barry houdini]

As you have Excel 2010 you can utilise NETWORKDAYS.INTL function, try this formula in E2 copied across

=MAX(0,NETWORKDAYS.INTL(MAX(E$1,$A2),MIN(EOMONTH(E$1,0),$B2),11))

format cells as 0;; if you don't want zeroes to display

 

[Ron Coderre]

As you have Excel 2010 you can utilise NETWORKDAYS.INTL function, try this formula in E2 copied across

=MAX(0,NETWORKDAYS.INTL(MAX(E$1,$A2),MIN(EOMONTH(E$1,0),$B2),11))

format cells as 0;; if you don't want zeroes to display

Thanks, Barry... Now THAT I can explain! (It's going in my formula stash)

 

[T. Valko]

As you have Excel 2010 you can utilise NETWORKDAYS.INTL function, try this formula in E2 copied across

=MAX(0,NETWORKDAYS.INTL(MAX(E$1,$A2),MIN(EOMONTH(E$1,0),$B2),11))

format cells as 0;; if you don't want zeroes to display

I'm going to have to get me some Excel 2010...



...but first I need to get a new computer!

 

[jim may]

Ron, I LOVE it -- but,,,, how the heck can you write something, without being able to explain it. LOL --- Thanks Very Much -- I still have no idea where i would have ended up going with it... LOL

 

[FarmAccountant]

YOU ARE ALL INCREDIBLE!!! I can't thank you all enough for this!!!!!