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

Posted on Dec 6, 2025 9:09 PM

Reply
Question marked as Top-ranking reply

Posted on Dec 6, 2025 11:35 PM

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.

1 reply

Adding a condition to a cell with a Date

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.