Roger,
Thanks again - I'll work on that awhile. In the mean time, I wonder if you
wouldn't mind answering another date question for me. I have a column of
dates in excel in the following format:
20051209

The normal way of changing date formats (format, cell, date) does not change
the format. Is there a way to display these dates in a more traditional
format such as:
12/09/2005, or 12/09/05??

Thanks in advance for your help!

Julie Young




--
Julie


"Roger Govier" wrote:

Hi Julie
With 1/12/05 in A1,
=EOMONTH(A1,0) would return 31/12/05, i.e. the end of month December, held
in A1.
For Yearstart, I was expecting you to either substitute the cell holding the
date of your yearstart, or alternatively InsertNameDefineYearstart
Refers to 01/01/05.

You are getting the #Name error, because yearstart isn't defined as a name (
I should have been more explicit in my first post).
So, if EOMONTH(A1,0) returns the last day of January, EOMONTH(A1,11) will
return the last date of December. Substitute whatever months you like, but
basically it will give you the end of the period 12 months from the start.

The formula, when used with TODAY() and whatever your Yearstart is, is
automatically defining your multiplication factor.

Regards

Roger Govier


Julie wrote:
Thank-you fore your response. The data comes from our company accounting
system that changes by the minute. I run a query for Year to date parts
sales by customer and the data that is dumped into excel is every part that
has been sold to each customer YTD up to that moment. When running the
report today, I multiply every YTD sales figure by the constant 1.064 which I
calculate by dividing 365 by 343, which is the number of days of sales that
YTD represents. If I were to run the report on July 1, I would multiply by
2, etc.

I went to toolsaddinsAnalysis Toolpak, then tried your equation in place
of my constant. I got an error message that read #NAME?. I don't really
understand the equation - what does the 11 mean?