dates being converted to serial problems

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.
 
G

Guest

unfortunately that didn't help.
formatting as date for some reason is still seeing the
serial but showing the date properly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Display weeks from a Milestone 0
Finding the right style field in VBA 0
Formula I can't figure out 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
countifs Function not giving desired result with date criteria 2
Removal Date 6
formatting a spreadsheet help 4

Top