[linderman]

Thank you for taking the time to look at my question


I am currently in the process of migrating from one pedigree program to another becuase my old one wont work in Windows 7

The program that contains all my data is based upon clarion topspeed which fomats all dog DOB's into a long date format instead of the way we are accustomed to seeing it (mm/dd/yy)

with plenty of google searching I have found clarion uses a starting point of dec 28 1800 then adds the number of days which have elapsed since then when I enter data. Now I must convert these numbers into a usable date which I have been told is easy to do with an excel formula ? but I am a super noob with excel; I have spent wayyyyy to much time with hardware :banghead:

would anyone be willing to help me write such a macro and explain how to use it in excel ?

here is a link to where I found somewhat of an explantion
The Clarion Advisor: Displaying Clarion Dates In Excel

a typical exaqmple of a clarion date I have in my data base is 70805 which means this dog was born on 11/06/94

I would be most elated if anyone could assist me.

best regards

 

[linderman]

Re: Help with excel macro for data conversion

more info on the subject


Quote:

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.