almouchie
02-01-2006, 03:22 AM
IT may be a little stupid the question
but forgive me before hand
I have an if statement that should refer to a cell
if its blank G (date format) & H which id the bill number (format general)are blank
then subtract the date in F (purchase date) from today's date
if not (blank) then subtract the date in F from the bill date in G
IF(G2<0,Networksdays(F2,H2),NETWORKDAYS(F2,TODAY()))
using G> or <o doesn't do the trick for both cases
Thanks in advance
but forgive me before hand
I have an if statement that should refer to a cell
if its blank G (date format) & H which id the bill number (format general)are blank
then subtract the date in F (purchase date) from today's date
if not (blank) then subtract the date in F from the bill date in G
IF(G2<0,Networksdays(F2,H2),NETWORKDAYS(F2,TODAY()))
using G> or <o doesn't do the trick for both cases
Thanks in advance