Need some help for a formula
a date is before another date I need excel to return a text
for instance if 4/6/14 is before 4/29/14 I need it to return "Before Warranty"
Capture.PNG
Need some help for a formula
a date is before another date I need excel to return a text
for instance if 4/6/14 is before 4/29/14 I need it to return "Before Warranty"
Capture.PNG
Surely just
=IF(A1<B1,"Before Warranty","")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thanks. Apparently I was trying to over complicate the issue. I guess sometimes it pays to go back to the basics.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks