Hi I am trying to do multiple formula’s to get a time period between when different things happen. the issue is some of these fields are going to be blank as in they have not be been completed yet so the field is left blank. i would like to create a new column with a time period of days between one date “PLR Job No.Date” – “Booked in Date”.

To start with i tried the basic part “=calculate(sum(‘table 1′[booked in date]))-calculate(sum(‘table 1′[PLR Job No.Date]))”. it was even at this stage which it fails as there is a string.

i would then like to embed it into an if statement stating if the “‘table 1′[PLR Job No.Date]” is blank then do the formula – today().

enter image description here