View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Query equasion for dates

Thank you all, here is the answer:
Column 1 gives you todays date. Column 2 gives you the date of transaction.
Column 3 provides a dynamic equation for financials.
For me, this is used for keeping a running list on investment days for
interest.

Column 1 Column 2 Column 3
=today () date of transaction =A1-B1
Right click Right click
-Format Cells -Format Cells
-Number -Number
-Set decimal @ 0 -Set decimal @ 0

Best,
Dave