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
|