compare date

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi,

I have a worksheet with different tabs for the different sales people. I'm
trying to follow up the price offers they make.
So in column A there is the name of the customer, in column B is the due
date for the price offer. Column C will be the date of the actual price
offer.
What I would like to do is to compare the dates in column B with the
Today-date and if a or some dates in column B are equal to or past the
Today-date, get a message box allerting me there are price offers due or
overdue.
The best should be if this comparison could be done on opening the
Excel-worksheet (for this I already have the VBA-code), but for all the
different sales people.

I hope I'm not asking for anything impossible.
Thanks in advance,

Chris
 
Welcome the world of binary numbers! Like all computer programs (except
perhaps COBOL), Excel uses the IEEE convention to convert decimal numbers
(number on base 10) to binary (numbers on base 2). With a finite numbers of
bits, this can give rise to what we call 'rounding errors'. For details read
one or more of these:
IEEE 754
Floating-point arithmetic may give inaccurate results in Excel
http://support.microsoft.com/kb/78113/en-us
(Complete) Tutorial to Understand IEEE Floating-Point Errors
http://support.microsoft.com/kb/42980
What Every Computer Scientist Should Know About Floating Point
http://docs.sun.com/source/806-3568/ncg_goldberg.html
http://www.cpearson.com/excel/rounding.htm
Visual Basic and Arithmetic Precision
http://support.microsoft.com/defaul...port/kb/articles/Q279/7/55.ASP&NoWebContent=1
best wishes
 
Bernard,
I'm not so deep in all this, but when I have a function
"=IF(A1<TODAY();TODAY()-A1;"") where A1 is a date, I get a value returned.
What I am looking for is a macro that contains/executes this function, but
for the whole column A and that will generate a message box if there are
rows where there is a difference between the two dates (overdue).

I read the articles you mentioned, but I don't understand the influence of
the rounding in regard of my question (newbee ignorence?).

Best regards, Chris
 
Back
Top