This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 70%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGO%3C/text%3E%3C/svg%3E)
=IF([Revised Planned Date]="",PlannedFinishDate,[Revised Planned Date]) is the one working
However,
If Both Revised Planned Date and Planned Finish Date are blank show blank.
Currently shows 12/30/1899 in my output when both are blank.
=IF(PlannedFinishDate="","",IF([Revised Planned Date]="",PlannedFinishDate,[Revised Planned Date]))
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 51%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
Based on your original post, I understand that if Both Revised Planned Date and Planned Finish Date are blank, the calculated column shows blank. If not both Revised Planned Date and Planned Finish Date are blank, the calculated column shows the value same as Revised Planned Date. If I misunderstand your requirement, please correct me.
You could use following formula in the calculated column.
=IF(AND(ISBLANK([Revised Planned Date]),ISBLANK([Planned Finish Date])),"",[Revised Planned Date])
Result:
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Would you like to test above formula and share me the result?
If there is still any problem, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and kindly upvote it.
I'm checking how the things are going on about this issue. Whether the answer helps you?
If you find any answer is helpful to you, please remember to accept it. It will help others who meet the similar question in this forum. Thank you for your understanding.