Changing a formula's result to text output

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
 
F

firefytr

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for Dates and CF Colour then convert to Text 3
Excel formula to incrementally increase a value by 1 every 365 day 2
Conditional format refers to two cells 1
change the color of cell background based on a result 2
help with a function 1
DATEDIF vs. simple difference 5
Using a date formula! 2
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) 7

Top