# Revision history [back]

### [CALC] How to add days to a date

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 is below.

  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.

### [CALC] How to add days to a date

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.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.

### [CALC] How to add days to a date

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