SOLVED
Home

IF (logical;yes; no) How to use a Date function in the result ?

Platinum2000
New Contributor

I need to add a Date function as a result in an IF formula.

 

I tried =IF(R4>0;Date;"") but the result is #¿....  an error. 

 

How I would do it ?

 

Thank you any help

3 Replies
Solution
DATE must have arguments for YEAR, MONTH, and DAY. For example, your formula might look like this:
=IF(R4>0,
DATE(2019,3,18),
“”)
The formula returns March 18, 2019, if the value of R4 is more than 0; otherwise, it returns an empty text (“”).
Thank you Twifoo, it was a bad command I knew, I guessed at beginning maybe this IF command would not accept a funtion in its results, but then I saw a sample, so I thank you very much.
In the formula, DATE returns the value_if_true argument of IF. As you will discover, you can use a function to return an argument of another function. Good luck.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
18 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies