Vacation Days Accrued

I figured out why the error #NAME? was happening. There was just a space between some text. So far this works great!

Thank you SO MUCH!!! You are a life saver!

I have one more question Bernie. I'm trying to learn as I go here. In the formula:

=IF(DATEDIF(E6,TODAY(),"y")<10,DATEDIF(E6,TODAY(), "m")*3.34,400+DATEDIF(DATE(YEAR(E6)+10,MONTH(E6),D AY(E6)),TODAY(),"m")*6.67)

What does the 400 represent?

Thanks!

Just a guess on my part:

40 hrs per year for the first 10 years?

Cutter,

Ding ding ding ding! We have a winner... you are correct. :-)

Bernie


"Cutter" <Cutter.20csbn_1135106701.1611@excelforum-nospam.com> wrote in
message news:Cutter.20csbn_1135106701.1611@excelforum-nospam.com...
>
> Just a guess on my part:
>
> 40 hrs per year for the first 10 years?
>
>
> --
> Cutter
> ------------------------------------------------------------------------
> Cutter's Profile:
> http://www.excelforum.com/member.php...fo&userid=9848
> View this thread: http://www.excelforum.com/showthread...hreadid=494904
>