Forum Discussion
Solved
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)
I used the IF/BLANK formula, but my date fills in like this: 01/00/00
WHAT AM I DOING WRONG?