Clarion Date format for Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have exported some data from a sql database and I need to know how to
format a Clarion date. Help
 
Scott,

It would help us if you could define what a Clarion Date is....

HTH,
Bernie
MS Excel MVP
 
Well, you learn something new every day. From

http://www.clarionmag.com/cmag/v4/v4n12exceldates.html

"If you have a CSV file or other data that contains an unformatted Clarion
date, and you wish to view the date in Excel, you'll need to convert the
Clarion standard date to an Excel date.

Fortunately, that's easy to do. Just create a formula in another column,
subtracting 36161 from the value and formatting it as a date. Clarion
standard dates and the Excel DATE() function both have an arbitrary "Day
1" - for Excel, this is 1/1/1900, while Clarion's Day 1 is 12/28/1800
(although the first usable date is Day 4, or 1/1/1801). The number 36161 is
the difference in days between these two dates."


HTH,
Bernie
MS Excel MVP
 
Back
Top