Adding a condition to a cell with a Date
A formula to add a condition to a cell which contains a Date360 formula
iPhone 14 Pro Max, iOS 26
A formula to add a condition to a cell which contains a Date360 formula
iPhone 14 Pro Max, iOS 26
Only show the DATE360 result if a condition is true
Example: show the calculated date only if C1 is not empty:
=IF(NOT(ISBLANK(C1)), DATE360(A1, B1), "")
If C1 is blank → cell stays blank.
If C1 has a value → shows the DATE360 result.
Adding a condition to a cell with a Date