R
ROn Stalenberg
I have a large SS. Dates were suplied in 4-21-1998 format. I need to calc the
difference between 2 dates. but the formula =MONTH(A3)-MONTH(A2) wont work. I
suspect that the supplied dates are in text format or something since I can't
change the formats using the Format/Cells/Dates method. How can I eiather get
the formula to work, or change the date format of the supplied data?
(Someone did reply to this earlier, but the link didn't connect.)
Thanks
Ron S
difference between 2 dates. but the formula =MONTH(A3)-MONTH(A2) wont work. I
suspect that the supplied dates are in text format or something since I can't
change the formats using the Format/Cells/Dates method. How can I eiather get
the formula to work, or change the date format of the supplied data?
(Someone did reply to this earlier, but the link didn't connect.)
Thanks
Ron S