Ask Your Question
0

Check A Cell Date Against Current Date [closed]

asked 2017-08-31 23:30:14 +0100

simontfs gravatar image

updated 2020-08-04 17:58:43 +0100

Alex Kemp gravatar image

Hi Community.

Cell A1 = 01/09/2017

can I Ask Calc To Check the date in Cell A1 against the Current Date?

Maybe this would be done via an internet time server?

Thank-you for any help and guidance.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-04 17:58:50.923340

1 Answer

Sort by » oldest newest most voted
0

answered 2017-09-01 01:05:38 +0100

robleyd gravatar image

updated 2017-09-01 01:09:31 +0100

See the functions TODAY() and NOW()
From the Help:

NOW

Returns the computer system date and time. The value is updated when you recalculate the document or each time that a cell value is modified.

TODAY

Returns the current computer system date. The value is updated when you reopen the document or modify values in the document.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2017-08-31 23:30:14 +0100

Seen: 643 times

Last updated: Sep 01 '17