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.
I still get "NAME" msg.
Not sure what to tell you - I copy/pasted it directly from your post, added the parentheses, and it works fine for me.
- Sorry. Your response is correct except it needs apostrophes around y.
- Yes, quotes - sorry about that.