formula if date entered into a different cell if not left blank instead of invalid data type.

rob.begley

Hi I am using a formula which works really well to calculate worked days based on dates entered in two different columns, however if dates in those columns have not yet been entered, the cell showing the calculation shows invalid data type, i want the formula to work if date is in a column and show nothing if the date is yet to be entered.

cheers

Rob

hope this makes sense.

Andrée Starå

Hi @rob.begley

Try something like this. (replace the column names with yours)

=IF(OR([Date 1]@row = ""; [Date 2]@row = ""); "")

The same version but with the below changes for convenience.

=IF(OR([Date 1]@row = "", [Date 2]@row = ""), "")

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

rob.begley

Thank you so much for the reply

I will check this out as soon as I get back to the office later today

Andrée Starå

@rob.begley

Excellent!

You're more than welcome!

rob.begley

Hi Andree

cant quite get it to work

the formula I am using in the working days including termination and relet column is =NETWORKDAYS(Termination4, Relet4, $[Bank holidays 2020]$1:$[Bank holidays 2020]$8)

SharedScreenshot.jpg

I want it to show as nothing if a date is not entered into Termination and relet columns

many thanks

Rob