Thread: Formula for comparing a date to today's date
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
  
Posts: 751
Default Formula for comparing a date to today's date
wrote:
I am not familiar with the A:A, B:B notation. Is this an array form? Can I
look into a date in mid cycle to get the cummulative total to date?


A:A means the entire column A:A and it is (almost) identical to saying
A1:A65536. The formula
=AVERAGE(A:A)
will produce an average of all the numbers in column A. This is a good
technique when your column builds gradually and you want to monitor the
current average in another cell.

HTH
Kostis Vezerides

Reply With QuoteReply With Quote