G Guest Feb 12, 2005 #1 If I have a date range of 4/15 - 7/30, how do I pull out the workdays per month? April - # May - # June - # July - # Thanks, -pete
If I have a date range of 4/15 - 7/30, how do I pull out the workdays per month? April - # May - # June - # July - # Thanks, -pete
P Peo Sjoblom Feb 12, 2005 #2 April =NETWORKDAYS(DATE(2005,4,15),DATE(2005,4,30),Holidays) adapt to fit for the rest -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum)
April =NETWORKDAYS(DATE(2005,4,15),DATE(2005,4,30),Holidays) adapt to fit for the rest -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum)
G Guest Feb 12, 2005 #3 Thanks Peo. I think I need to be more clear in what I'm asking. What I want to come out with is something like this: April | May | June | July 4/15/2005 | 7/15/2005 12 20 22 10 6/15/2005 | 7/31/2005 I've tried this: MAX(0,NETWORKDAYS(MAX(T$1,$E4),MIN(DATE(YEAR(T$1),MONTH(T$1)+1,0),$F4))) But it is coming up 2 days short... Any help would be appreciated.
Thanks Peo. I think I need to be more clear in what I'm asking. What I want to come out with is something like this: April | May | June | July 4/15/2005 | 7/15/2005 12 20 22 10 6/15/2005 | 7/31/2005 I've tried this: MAX(0,NETWORKDAYS(MAX(T$1,$E4),MIN(DATE(YEAR(T$1),MONTH(T$1)+1,0),$F4))) But it is coming up 2 days short... Any help would be appreciated.
D Daniel.M Feb 12, 2005 #4 Hi, With A2: start date B2: end date holidays: your range of holidays (omit from formula if you have none) C1: 1st Jan D1: 1st Feb drag until O1 (1st Jan next Year) In C2: =MAX(0,NETWORKDAYS(MAX(C$1,$A2),MIN(D$1-1,$B2),holidays)) Copy C2 till N2 Obviously, your year can start in April (1st Apr in C1, 1st May in D1, etc.) and the logic stays the same. Daniel M.
Hi, With A2: start date B2: end date holidays: your range of holidays (omit from formula if you have none) C1: 1st Jan D1: 1st Feb drag until O1 (1st Jan next Year) In C2: =MAX(0,NETWORKDAYS(MAX(C$1,$A2),MIN(D$1-1,$B2),holidays)) Copy C2 till N2 Obviously, your year can start in April (1st Apr in C1, 1st May in D1, etc.) and the logic stays the same. Daniel M.
