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
Bookmarks