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.
6 Replies
- 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.
- 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.
