Hello,
I am trying to figure out the formula for the following: Starting in G2 I want to add a 1 when the dates in C2 and D2 are within the range of G1 and continue on for each cell down and across. The formula I have now does that. However, I cant figure out how to make a formula where:
Add a 1 if the date in C2 (TO) starts on the 1st to the 14th and do not add a 1 if the date in C2 starts on the 15th or later.
Do not add a 1 if the date in D1 (FROM) is 1st through the 14th and add a 1 if the date is on the 15th or later.
thank you!
I am trying to figure out the formula for the following: Starting in G2 I want to add a 1 when the dates in C2 and D2 are within the range of G1 and continue on for each cell down and across. The formula I have now does that. However, I cant figure out how to make a formula where:
Add a 1 if the date in C2 (TO) starts on the 1st to the 14th and do not add a 1 if the date in C2 starts on the 15th or later.
Do not add a 1 if the date in D1 (FROM) is 1st through the 14th and add a 1 if the date is on the 15th or later.
thank you!
![vhuvrc.png](/board/proxy.php?image=http%3A%2F%2Fi63.tinypic.com%2Fvhuvrc.png&hash=6e521760f00280bc9d1ba12465303884)