Hello, I'd like to calculate the number of days between dates -- Excel 2007
I've formatted the columns to Dates-- Aust so they read 23-12-2006 etc
when I put =C3-B3 for the below , I get a #value instead of 11 days
ColB ColC ColD
23-12-1992 03/01/1993 #VALUE!
can someone advise where I'm going wrong please
thanks Keith
I've formatted the columns to Dates-- Aust so they read 23-12-2006 etc
when I put =C3-B3 for the below , I get a #value instead of 11 days
ColB ColC ColD
23-12-1992 03/01/1993 #VALUE!
can someone advise where I'm going wrong please
thanks Keith