Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do I get a #Name error when I use the DateDif function? | Excel Worksheet Functions |