Date conversion to another form

[mo24]

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?

[ChemistB]

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

=RCHGetYahooHistory("GOOG",YEAR(A1),MONTH(A1),DAY(A1),etc...)

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

Does that work?

ChemistB

[mo24]

ChemistB,

That works perfectly! Thank you!