Hi,

I need help on the IF formula to show results based on the number of days between two dates using multiple conditions.

For Ex:

If col A has date 11/24/2020 and Col B has same date 11/24/2020 then the column C should reflect "T+0"
If col A has date 11/24/2020 and Col B has same date 11/25/2020 then the column C should reflect :"T+1"
If col A has date 11/24/2020 and Col B has same date 11/26/2020 then the column C should reflect :"T+2"

and so on..

How can I do this using IF formula.

Appreciate your assistance.

Thanks,
Arun