Out Date "OUT" or Return Date "Return"

luisitocarrion1900

Board Regular
Joined
Oct 30, 2017
Messages
51
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
32,440
Office Version
365
Platform
Windows
How about
=if([@[Return Date]]>0,"Return",if([@[Out Date]]>0,"OUT",""))
 

Forum statistics

Threads
1,082,587
Messages
5,366,486
Members
400,894
Latest member
frog9000

Some videos you may like

This Week's Hot Topics

Top