Date conversion to another form

Hello,

I currently use a free add-in written by Randy Harmelink to retrieve the price of a stock at a given date. In my spreadsheet, I have a large number of dates listed in date format (ie: 1/1/1998) in Column A, but the actual data for the dates is listed by Excel in the form (ie: 28491) if I change the formatting to general.

For the add-in, I typically use the function:
=RCHGetYahooHistory("GOOG",1998,1,1,etc...) which is in the form Year,Month,Day.

What I would like to do is to be able to essentially do this:
=RCHGetYahooHistory("GOOG",A1,etc...) or in other words, pass the date in Column A to the function in the correct format. But i'm not sure how to do this when Excel stores the date in the form '28491' in A1.

How I might accomplish this?

The FUNCTION takes year, month and day as separate arguments so that you can't simply reference A1. It might work if you use this

Please Login or Register  to view this content.

A1 can be formatted any way you like (except as text).

Does that work?

ChemistB

ChemistB,

That works perfectly! Thank you!