jcountry22
New Member
- Joined
- Aug 15, 2014
- Messages
- 36
I'm trying to figure out a formula with an IF statement to generate the words SHIPPED or BACKLOG based on dates.
starting Cell A2 = Order date, 1/1/17
Cell B2 = ship date, 2/1/17
If ship date is blank, generate "BACKLOG" text
if ship date > order date = "SHIPPED" text
text should appear in cell C2
starting Cell A2 = Order date, 1/1/17
Cell B2 = ship date, 2/1/17
If ship date is blank, generate "BACKLOG" text
if ship date > order date = "SHIPPED" text
text should appear in cell C2