Forum Discussion

Melissa Eschweiler's avatar
Melissa Eschweiler
Copper Contributor
Sep 17, 2018
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?      
Formulas and Functions
  • MrBond1's avatar
    MrBond1
    Sep 17, 2018

    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)

SLCWORDEN73's avatar
SLCWORDEN73
Copper Contributor
Feb 10, 2026

I used the IF/BLANK formula, but my date fills in like this: 01/00/00

WHAT AM I DOING WRONG?

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 11, 2026

Most probably you return blank cell with formula. It's considered as zero, or zero date (Jan 00, 1900) if to apply date format.