Jun 03 2024 12:24 PM
What is wrong with this formula? =SUM(DATEVALUE(G2))-TODAY() it returns #VALUE ??
Jun 03 2024 12:51 PM
@leslie919
There is no need to use SUM here. The formula is equivalent to
=DATEVALUE(G2)-TODAY()
What does G2 contain?
Jun 03 2024 01:52 PM
5/26/2024 @Hans Vogelaar
Jun 03 2024 02:58 PM
If G2 is a real date, you shouldn't use DATEVALUE.
Does this work?
=G2-TODAY()
Format the cell with the formula as General.
