Re: [amibroker] Match date from numeric date in Excel?

[Keith McCombs]

In Excel, assume your date is in cell F5 {in Date format}.  Then equation for AFL format is: =(YEAR(F5)-1900)*10000 + MONTH(F5)*100 + DAY(F5) {in General format} -- Keith cstrader232 wrote: I want to match a numeric date variable from an Excel file to a numeric date value that AFL understands. (has to be numeric to work in a loop) My options in Excel seem to be: Number of days since January 1, 1900 "julian" date in yyyy, num days since 1/1 format: e.g. 2006153 But can either of these be matched to datetime()? I don't want to have to use 3 separate numeric variables: M D Y TIA ------------------------ Yahoo! Groups Sponsor --------------------~--> Home is just a click away.  Make Yahoo! your home page now. http://us.click.yahoo.com/DHchtC/3FxNAA/yQLSAA/GHeqlB/TM --------------------------------------------------------------------~-> Please note that this group is for discussion between users only. To get support from AmiBroker please send an e-mail directly to SUPPORT {at} amibroker.com For other support material please check also: http://www.amibroker.com/support.html Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/amibroker/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ Please note that this group is for discussion between users only. To get support from AmiBroker please send an e-mail directly to SUPPORT {at} amibroker.com For other support material please check also: http://www.amibroker.com/support.html SPONSORED LINKS Investment management software Real estate investment software Investment property software Software support Real estate investment analysis software Investment software YAHOO! GROUPS LINKS  Visit your group "amibroker" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.