Hi all Excelers
I have a problem which I really need help with, pretty please.
I shall try and be as concise as possible
B3 contains a date, I am using a formula to calculate how long a piece of data is missing from D3. So far I am using this formula: =IF(ISBLANK(D3),NETWORKDAYS.INTL(B3,TODAY(),1,'Bank Holidays '!$A$1:$A$8),"")
this works well in effect - however - for cells further down that have not yet had their date populated (inside B column), a long number is entered (31002) to the cell which the above formula is entered to (0 column).
what I need and want is for O column cells to remain empty until the date in B3 is entered for the formula to then do its magic.
Any advice would be great, thank you, Jord
Bookmarks