Forum Discussion
IF date is blank enter today's date....help
This should be simple.....
If g2 is blank, enter today's date, otherwise use g2.
=If(G2="", Today(),G2)
this isnt working?
Try this. Also if the field is set to general, the result will be numbers, so make sure to set the type to date.
=IF(ISBLANK(G2),TODAY(),G2)
Try this. Also if the field is set to general, the result will be numbers, so make sure to set the type to date.
=IF(ISBLANK(G2),TODAY(),G2)Melissa, it works if only G2 is really blank
That worked.
Thank You!
Just in case
