I want to create a formula with two different date, final count is from credit approve date?

NEW IN SMARTSHEET

=IF([CREDIT APPROVED]@row = 0, TODAY() - [CASH APPROVED]@row, TODAY() - [CREDIT APPROVED]@row)

Genevieve P.

Hi @NEW IN SMARTSHEET

Assuming that the first two columns are Date type of columns, you'll want to search to see if the cell is blank, not 0. Then the rest of your formula would work!

=IF([CREDIT APPROVED]@row = "", TODAY() - [CASH APPROVED]@row, TODAY() - [CREDIT APPROVED]@row)

See: Use Formulas to Perform Calculations With Dates

Cheers,

Genevieve

Genevieve P.

Hi @NEW IN SMARTSHEET

Assuming that the first two columns are Date type of columns, you'll want to search to see if the cell is blank, not 0. Then the rest of your formula would work!

=IF([CREDIT APPROVED]@row = "", TODAY() - [CASH APPROVED]@row, TODAY() - [CREDIT APPROVED]@row)

See: Use Formulas to Perform Calculations With Dates

Cheers,

Genevieve

NEW IN SMARTSHEET

Hi Ms @Genevieve P. ,

Thank you very much!

Cheers,