In Column A is “DATE”, Column B is “Open/Close”.
I would like Column B to say “Open” if the date is less then 30 days and “Close” once it passed the 30th day.
I’m at lost trying to get this to work. Sample of my output I would like is below (included the file as well).
A B
date open/close
01/01/19 close
03/14/19 open
Ahead of time, a Big “Thanks” for any and all help with this.