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

[NotSoFamous]

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?

[#2]

You will need parentheses around the "y", but otherwise looks okay to me.

[#3]

I still get "NAME" msg.

[#4 · Accepted 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.

[#5]

Reply is correct except it must have apostrophes (") around y (not parentheses). Thank you JMB17.

[#6]

Sorry. Your response is correct except it needs apostrophes around y.

[#7]

Yes, quotes - sorry about that.