If I have the title "Comm" in Cell A, then I want Cell C1 to be whatever Date Cell B has + 14 days. If I have "Recruit" in Cell A, then I want Cell C1 to be whatever Date Cell B has + 30 days.
pasted in cell C1 =if(A1="Comm","B1+14,"")")
The result was False - what I need is a date +14 days from Cell B's entry.
Aucun commentaire:
Enregistrer un commentaire