Using IF Statement & DATE

bsmith736464

I'm trying to combine formulas that if a check box is clicked, it returns the number 7 to me or else it runs a formula for subtracting dates from TODAY but unfortunately I keep getting #INVALID DATA TYPE

=IF(OR(COMPLETE@row, "7"), (TODAY() - DATE@row))

Any help would be great appreciated. Thanks.

Frank Falco

Assuming COMPLETE is a check box then try

=IF(COMPLETE@row=1,7,TODAY() - DATE@row)

Evaluating a checkbox is 1 if selected, 0 if not. So thus the COMPLETE@row=1 .

If the is true, then return 7, else return the number of days between the date and today.

Frank Falco

Assuming COMPLETE is a check box then try

=IF(COMPLETE@row=1,7,TODAY() - DATE@row)

Evaluating a checkbox is 1 if selected, 0 if not. So thus the COMPLETE@row=1 .

If the is true, then return 7, else return the number of days between the date and today.