Changing a formula's result to text output

  • Thread starter Thread starter DarrenColeman
  • Start date Start date
D

DarrenColeman

I am using this formula =DATEDIF(D4,TODAY(),"d") to calculate the day
past a certain date with current date. What I'd like to see in the cel
is if days result is less than 365 the cell would display "Warranty
and if greater than 365 the cell would display "Expired". Is there
formula for this
 
hello,

you didn't specify about the actual 365, so i took a little assumption.
but this should do you right...

=IF(DATEDIF(D4,TODAY(),"d")<=365,"Warranty","Expired")
 
Back
Top