Make a cell empty if adjacent cell is empty

Question

I have a spreadsheet where I record the date I sent a document to someone to make a decision.

that date is record in column F.

In column G I have a formulae calculating what date that person should have their decision back to me which is

=WORKDAY(F2, 10)

but if theres no date in column F for a given row then it generates a date of 13/01/1900 (10 working days after 01/01/1900).

so how do I adapt the formulae so for example if cell F7 is blank then G7 will be blank instead of 13/01/1900. but if  date later gets entered into F7 G7 will populate the correct due back date (10 working days later.)

It would also be useful if excel could automatically account for all uk bank holiday dates past and future without me having to set them up somewhere so it gives me the most accurate possible result.

any ideas?

Answer 1

Just type the dates into a list as the below screenshot. Highlight all the cells in the list and then type your named range of Hols into the top left box as shown and then press enter.

Under Formulas, Name Manager you will see Hols appear and the range it refers to. Should you add any more dates to your list, simply change the Refers to range to cover the new entries.

Answer 2

How do you setup the holiday date range? lets say I store those dates in a separate tab along the bottom.

Answer 3

You will have to set up a range of dates that are the UK Bank holidays dates. You can then name this range something like Hols

Your formula could then be

=IF(F2="","",WORKDAY(F2,10,Hols))