Hi All,
I need to calculate the number of days between two dates.
The database is downloaded from the web.
For one reason or another, LEN=5 for some dates and LEN=10 for the rest.
My formula is...
I have one column for Units and one column for Price.
Commission is calculated based on first $100 x 1% plus remainder x 0.5%.
Is there any quick formula for this?
Many thanks!
BM