Hi,

I've written the following code to related to finding the last working day in the event of bank holidays.

=IF(AND(VLOOKUP(TODAY()-1,'Bank Holidays'!A:B,2,FALSE)="BH",(VLOOKUP(TODAY()-2,'Bank Holidays'!A:B,2,FALSE)="BH")),WORKDAY(TODAY(),-3),IF(AND(VLOOKUP(TODAY()-1,'Bank Holidays'!A:B,2,FALSE)="BH",(VLOOKUP(TODAY()-4,'Bank Holidays'!A:B,2,FALSE)="BH")),WORKDAY(TODAY(),-3),IF(AND(VLOOKUP(TODAY()-1,'Bank Holidays'!A:B,2,FALSE)="BH",(VLOOKUP(TODAY()-2,'Bank Holidays'!A:B,2,FALSE)="")),WORKDAY(TODAY(),-2),WORKDAY(TODAY(),-1))))

The problem is I need to repopulate a cell with this each time the spreadsheet opens. I think the code is too long as when i try and record this to a macro excel tells me I can't record. Does anyone knnow how to get round this?