Earned Vacation time Formula
 

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()<=dat e(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

Earned Vacation time Formula
 

Not very sure, maybe you meant this:
=IF(YEAR(TODAY())<2008,"",IF(TODAY()<=DATE(2008,1 2,31),TODAY()-DATE(2008,1,1)*0.22,0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Savage666" wrote:
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()<=dat e(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

Earned Vacation time Formula
 

Savage --

Another similar route:

=IF(YEAR(TODAY())=2008,(TODAY()-DATE(2008,1,1))*0.22,"")

For May 28, returns 32.56.

HTH

"Savage666" wrote:

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()<=dat e(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