Forum Discussion
Solved
use cell address as reference in =DATEDIF((I2),DATEVALUE("2022/2/28"),y)
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?
Not sure what to tell you - I copy/pasted it directly from your post, added the parentheses, and it works fine for me.
You will need parentheses around the "y", but otherwise looks okay to me.
Reply is correct except it must have apostrophes (") around y (not parentheses). Thank you JMB17.