S
Savage666
I think i have the formula down, but i keep receiving error messages. i think
it is a bracket problem, but no one here understands enough to help. I've
been looking at it for hours now and think i've just lost perspective.
=if((today()>=Date(2009,01,01)),"",if(today()<=date(2007,12,31)),"",IF(TODAY()<=(DATE(2008,12,31))),((TODAY()-(DATE(2008,1,1)))*0.22),IF(TODAY()>=(DATE(2008,12,31))),((TODAY()-(DATE(2008,1,1)))*0.22),0))
i was hoping that if the current date was outside the parameters it would
simply show up blank, otherwise it would process the formula regularly
showing {number of days this year} * 0.22.
Excel-03
it is a bracket problem, but no one here understands enough to help. I've
been looking at it for hours now and think i've just lost perspective.
=if((today()>=Date(2009,01,01)),"",if(today()<=date(2007,12,31)),"",IF(TODAY()<=(DATE(2008,12,31))),((TODAY()-(DATE(2008,1,1)))*0.22),IF(TODAY()>=(DATE(2008,12,31))),((TODAY()-(DATE(2008,1,1)))*0.22),0))
i was hoping that if the current date was outside the parameters it would
simply show up blank, otherwise it would process the formula regularly
showing {number of days this year} * 0.22.
Excel-03