Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

[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

C:\fakepath\add date.ods

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

C:\fakepath\add date.ods

Ahead of time, a Big "Thanks" for any and all help with this.