Forum Discussion
Due Date that auto updates
I am trying to write a formula for a Due Date that will automatically update to the new Month/Day/Year, but only if the value in cell F4 equals ANY of the following: "Cancelled", "Paid", "Paid Off", ...
Pls check the posted question again twint022
You have written "--IF BOTH CONDITIONS ARE TRUE, then cell E4 will extract the Year and Month from A1 and enter the day as 1.
---IF ONE OR BOTH ARE FALSE it will extract the Year and Month from cell A1 and enter the day as 1. "
Both the clause are same, Kindly check & revert. (external link removed by moderator)