Ask Your Question
0

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

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

_dave gravatar image

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

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
0

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

gregors15 gravatar image

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

edit flag offensive delete link more

Comments

Thanks, that work for me.

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

Question Tools

1 follower

Stats

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

Seen: 188 times

Last updated: Mar 14