=DATEDIF
 

Hello All,

I'm using this formula, =DATEDIF(E8,NOW(), "y" ). This returns a 1. I have a
spread sheet that determines if an instrument needs to be calibrated after
it's year calibration is up. I would like to use a nested IF statement so
that when the one year calibration is up it will return a text string "NEEDS
CALIBRATION" instead of a 1.

Thanks,

=DATEDIF
 

=if(DATEDIF(E8,NOW(),"y")=1,"Needs Calibration","Not Yet")

Excel User001 wrote:

Hello All,

I'm using this formula, =DATEDIF(E8,NOW(), "y" ). This returns a 1. I have a
spread sheet that determines if an instrument needs to be calibrated after
it's year calibration is up. I would like to use a nested IF statement so
that when the one year calibration is up it will return a text string "NEEDS
CALIBRATION" instead of a 1.

Thanks,

--

Dave Peterson

=DATEDIF
 

Works great!!! Thank you very much for all your help!

"Excel User001" wrote:

Hello All,

I'm using this formula, =DATEDIF(E8,NOW(), "y" ). This returns a 1. I have a
spread sheet that determines if an instrument needs to be calibrated after
it's year calibration is up. I would like to use a nested IF statement so
that when the one year calibration is up it will return a text string "NEEDS
CALIBRATION" instead of a 1.

Thanks,