Thread: Query equasion for dates
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default Query equasion for dates
Column 1
=today ()
Right click
-Format Cells
-Number
-Set decimal @ 0

Column 2
date of transaction
Right click
-Format Cells
-Number
-Set decimal @ 0

Column 3
=A1-B1




Reply With QuoteReply With Quote