Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#num fix
I have a formula to calculate longevitity years: In column u some new
service dates are in the year 2009 (school mothers based on hours to get a service date) = DATEDIF(U20,$V$3,"Y") the formula takes the date in u20(new service date) and subtracts from v3 (11/30/2008) and brings the "Y" ( which is total # of years). The ones with 2009 for the year in column u, give me a #num answer. Is there a way to have the formula fixed so these #num will bring a blank or 0 instead of #num? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#num fix
Try it this way:
=IF(ISERROR(DATEDIF(U20,$V$3,"Y")),0,DATEDIF(U20,$ V$3,"Y")) you can replace the 0 in the middle with "" if you prefer to see a blank cell. Hope this helps. Pete On Nov 25, 2:20*pm, Pammy wrote: I have a formula to calculate longevitity years: *In column u some new service dates are in the year 2009 (school mothers based on hours to get a service date) = DATEDIF(U20,$V$3,"Y") * the formula takes the date in u20(new service date) and subtracts from v3 (11/30/2008) and brings the "Y" ( which is total # of years). *The ones with * 2009 for the year in column u, give me a #num answer. *Is there a way to have the formula fixed so these #num will bring a blank or 0 instead of #num? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|