Out Date "OUT" or Return Date "Return"

luisitocarrion1900

Board Regular
Joined
Oct 30, 2017
Messages
57
I want that if Out Date column has a date, on the Status Column it will have the words OUT but when there's a date is Return Column it should say Return in the Status Column
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,412
Office Version
365
Platform
Windows
How about
=if([@[Return Date]]>0,"Return",if([@[Out Date]]>0,"OUT",""))
 

Forum statistics

Threads
1,084,799
Messages
5,379,946
Members
401,633
Latest member
DinnerB0ne

Some videos you may like

This Week's Hot Topics

Top