Forum Discussion
Formula error
What is wrong with this formula? =SUM(DATEVALUE(G2))-TODAY() it returns #VALUE ??
There is no need to use SUM here. The formula is equivalent to
=DATEVALUE(G2)-TODAY()
What does G2 contain?
5/26/2024 HansVogelaar
If G2 is a real date, you shouldn't use DATEVALUE.
Does this work?
=G2-TODAY()
Format the cell with the formula as General.
