Ive tried several versions but cant seem to get this working. Here is my example.
Formula for I5 - =IF(A5=Holidays,I4,F5+G5-H5)
So if the date in the A column equals one of the Holidays in a range, it will pull the last number from the previous day, if it is NOT a Holiday, it will provide the simple math for the current day. Hope you can follow this. I have tried instead of "Holidays" in the formula, which is a defined Name, also trying to link directly to the sheet and selecting the range. Each time this result is given as False. I am also having trouble geting the math going for the false return too.... Many future thanks