SOLVED

use cell address as reference in =DATEDIF((I2),DATEVALUE("2022/2/28"),y)

%3CLINGO-SUB%20id%3D%22lingo-sub-3221897%22%20slang%3D%22en-US%22%3Euse%20cell%20address%20as%20reference%20in%20%3DDATEDIF((I2)%2CDATEVALUE(%222022%2F2%2F28%22)%2Cy)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3221897%22%20slang%3D%22en-US%22%3E%3CP%3EDumb%20question%3A%26nbsp%3B%20How%20to%20use%20a%20cell%20address%20as%20reference%20in%20%3DDATEDIF((I2)%2CDATEVALUE(%222022%2F2%2F28%22)%2Cy)%20where%20I2%20is%20the%20cell%20with%202021%2F8%2F12%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3221897%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3222019%22%20slang%3D%22en-US%22%3ERe%3A%20use%20cell%20address%20as%20reference%20in%20%3DDATEDIF((I2)%2CDATEVALUE(%222022%2F2%2F28%22)%2Cy)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3222019%22%20slang%3D%22en-US%22%3EYou%20will%20need%20parentheses%20around%20the%20%22y%22%2C%20but%20otherwise%20looks%20okay%20to%20me.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3222045%22%20slang%3D%22en-US%22%3ERe%3A%20use%20cell%20address%20as%20reference%20in%20%3DDATEDIF((I2)%2CDATEVALUE(%222022%2F2%2F28%22)%2Cy)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3222045%22%20slang%3D%22en-US%22%3EI%20still%20get%20%22NAME%22%20msg.%3C%2FLINGO-BODY%3E
Occasional Contributor

Dumb question:  How to use a cell address as reference in =DATEDIF((I2),DATEVALUE("2022/2/28"),y) where I2 is the cell with 2021/8/12?

6 Replies
You will need parentheses around the "y", but otherwise looks okay to me.
best response confirmed by Grahmfs13 (Microsoft)
Solution

@NotSoFamous 

 

Not sure what to tell you - I copy/pasted it directly from your post, added the parentheses, and it works fine for me.

 

JMB17_0-1646073817668.png

 

Reply is correct except it must have apostrophes (") around y (not parentheses). Thank you JMB17.
Sorry. Your response is correct except it needs apostrophes around y.
Yes, quotes - sorry about that.