Ask Your Question

Check A Cell Date Against Current Date

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

simontfs 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 close merge delete

1 Answer

Sort by » oldest newest most voted

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:


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.


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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 397 times

Last updated: Sep 01 '17