Calculate working days between two dates using today's date if one cell is blank

[SaraWitch]

Hello peeps,

I have a formula that works out the number of working days, minus bank holidays, between two dates and if the second date is blank calculate using today's date.

The first date is in column AD and the second is in column AZ. I have a list of bank holidays in another sheet. I have had to minus a day because my formula always returned one day over the actual number of days! This is my working formula:

=IF($AZ5="",NETWORKDAYS($AD5,TODAY()-1,Lookups!$AI$3:$AI$10),NETWORKDAYS($AD5,$BA5-1,Lookups!$AI$3:$AI$10))

However, I want a blank cell if the first date in column AN is blank. My attempts so far have not been successful! The latest I have tried is:

=IF($AZ5="",NETWORKDAYS($AD5,TODAY()-1,Lookups!$AI$3:$AI$10),NETWORKDAYS($AD5,$BA5-1,Lookups!$AI$3:$AI$10),IF($AD5="",""))

Any help would be greatly appreciated...

 

[SaraWitch]

Sorry peeps!

Figured it out! I had AD column in the wrong place!

=IF($AD5="","",IF($AZ5="",NETWORKDAYS($AD5,TODAY()-1,Lookups!$AI$3:$AI$10),NETWORKDAYS($AD5,$BA5-1,Lookups!$AI$3:$AI$10)))

Thank you anyway if someone had a chance to look at this!