Can you please help me calculate the difference (in calendar days) between the two dates in columns A and B on both tabs (see attachment)Dates_comp.xlsx
. When I use the =DATEDIF(A7,B7,"d"), Excel returns a #VALUE! error, probably because it does not recognize the dates.
Thank you for your tremendous assistance!