Thread: Dates in Excel
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Chris Hankin Chris Hankin is offline
external usenet poster
 
Posts: 34
Default Dates in Excel

Thanks macropod,

I do not wish to use conditional formatting because the spreadsheet
contains several thousand line entries. Conditional formatting would
not be very practicle.

The dates in my spreadsheet are located in Column D. They are entered
in by the user as follows:

example: 01 Jun 2004

Column D is formatted: dd mmm yyyy

Please advise on how I can use your formula to print-out a list of
spreadsheet entries that have been in the database for exactly 14-days.

I am a newbie and would appreciate any help.

Thanks,

Chris.



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!