G
Guest
Hi,
I need some help on how to write a formula to calcuate this:
If column A is before today's date,
OR column B is < 0, then column C is 0,
otherwise, calculate networkdays between today's date and column A
What makes it more complicated is if the date in column A is beyond 2005
(for example, 3/1/06), I want the # of days from now till 3/1/06 to separate
out into
# of days from now till 12/31/05, and 1/1/05 till 3/1/06.
Currently, this is what I have and it doesn't work.
IF(OR(AG3<0,AE3<=$B$265),0,NETWORKDAYS($B$265,MIN(AE3,DATEVALUE("12/31/05")))
$B$265 is a reference cell.
THANX!
I need some help on how to write a formula to calcuate this:
If column A is before today's date,
OR column B is < 0, then column C is 0,
otherwise, calculate networkdays between today's date and column A
What makes it more complicated is if the date in column A is beyond 2005
(for example, 3/1/06), I want the # of days from now till 3/1/06 to separate
out into
# of days from now till 12/31/05, and 1/1/05 till 3/1/06.
Currently, this is what I have and it doesn't work.
IF(OR(AG3<0,AE3<=$B$265),0,NETWORKDAYS($B$265,MIN(AE3,DATEVALUE("12/31/05")))
$B$265 is a reference cell.
THANX!