Ask Your Question
0

Check A Cell Date Against Current Date

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

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
0

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

robleyd gravatar image

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

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

Question Tools

1 follower

Stats

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

Seen: 316 times

Last updated: Sep 01 '17