Thread: DATE Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default DATE Question

Measuring in months always raises questions. What would you think the
**date** that is one month before October 31, 2007? How about March 31,
2007?

Rick


"Terry" wrote in message
...
Hi, I have a file in which I have an order date column, the date is in the
form of MM/DD/YYYY, what i am trying to do is to find all files More then
a
month old from the current date. ie ( Todays date 10/11/2007) - 1 Month)
and
then give a list of files which fit the criteria.

Thanks in advance for your help.