Ask Your Question

SOLVED - [CALC] How to add days to a date

asked 2019-03-14 17:59:57 +0100

_dave gravatar image

updated 2019-03-14 19:44:49 +0100

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-03-14 18:47:01 +0100

gregors15 gravatar image

Try =IF(TODAY()-30>A1,"Close","Open")

edit flag offensive delete link more


Thanks, that work for me.

_dave gravatar image_dave ( 2019-03-14 19:41:13 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-14 17:59:57 +0100

Seen: 438 times

Last updated: Mar 14 '19