TODAY() function

  • Thread starter Thread starter sajida.x
  • Start date Start date
S

sajida.x

i am doin a worksheet on car insurance for a computing project. one o
the criteria is that if a customer is under the age of 25, 5 point
will be added to his record. if the refernce for the cell is E10 wa
formula would i use? am i using the rong funcion
 
Oops. You did say today so if customer date of birth as a date
where i2 has the date

=if(DATEDIF(I2,TODAY(),"Y")<25,5,0)
 
Back
Top