Formula within a formula

Laurie

Good afternoon everyone,

I was wondering if it is possible to do an IF formula with a date formula in the same cell?

I would like to do the following, but also subtract the number of working days between two dates.

IF(Status@row "Complete", 0, .....

Below is the formula I have now.

Thinh Huynh

HI @Laurie ,

I was wondering if it is possible to do an IF formula with a date formula in the same cell?

Yes, of course you can can. Try this formular:

=IF(Status@row="Complete"; 0; [End Date]@row - [Start Date]@row)

Hope it helps!

Laurie

Hi Thinh,

I tried this but it came back with UNPARSEABLE. Do you have any other suggestions?

Actually, I went back in and saw you put semi-colons, so I replaced those with commas and it worked great! Thank you!