dates being converted to serial problems

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

in my sheet, column a and column b have dates.
column b the dates are being seen properly as dates
column a they are being seen as date serials.

is there an easy way to correct this so that days360()
formula will work properly.

alternately, is there an easy way to convert the serial
date into a date that days360() formula will work properly.
 
unfortunately that didn't help.
formatting as date for some reason is still seeing the
serial but showing the date properly.
 
Back
Top