Forum Discussion

Re: Formula error

leslie919 

If G2 is a real date, you shouldn't use DATEVALUE.

Does this work?

=G2-TODAY()

Format the cell with the formula as General.

No RepliesBe the first to reply