Removing 28/01/1900 from empty cells

[kralin]

Hello

In column A I input a date

In column B there is a text column where users select from a dropdown either 'Priority' or 'Normal'

In column C there is a formula: =IF(B2 = "Priority", A2 + 5, A2 +28)

Column C is formatted as a date.

I have copied the formula input in column C down the column. This has led to the date 28/01/1900 appearing where Column A and column B have no values input.

Please can you let me know if I can tweak the formula above so instead of displaying '28/01/1900' when nothing has been input into corresponding A and B cells it displays " - " instead? I suspect a nested IF statement may do this but have been trying and failing to work it out.

I am using Professional 2019.


With many thanks

 

[awoohaw]

try:

=if(or(B2="",A2=""),"-",IF(B2 = "Priority", A2 + 5, A2 +28))

 

[kralin]

try:

=if(or(B2="",A2=""),"-",IF(B2 = "Priority", A2 + 5, A2 +28))

worked a treat. many thanks for taking the time to get back to me.

 

[awoohaw]

My pleasure!

Best Wishes!

 

[smozgur]

worked a treat. many thanks for taking the time to get back to me.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.