using sysdate in "if" function

A

Avinash

=IF(N21<="SYSDATE","B","O")

Above is the condition I want to use. But theresult i get is "B" only which
is not true as per the data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Style to 'Keep with previous' instead of Keep with Next 1
SYSDATE in Sql vba Recordset error 0
Apple Script in Outlook 365 Mac keystrokes blocked on M1 mac 0
Incorporating the User Profile location into a document template path 1
Formating bolded text exclusively. 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
XIRR vs. IRR Function 11
Trying to create custom labels from an csv file + Need items numerically counted out 0

Top