Dear All
I also need a Excel sheet that calculate automatically on daily basis. Exp.
One member register for 3 month starting day 4 May and end date 4Aug total
fee $150, the revenue should divide in way of valid days of the month , the
month of May should get 4 day revenue and Jun should get 30 day revenue July
should get 31 day share and Aug should get 4 day revenue.
Share of the month
Per day Revenue. 2.17
May 4 day=8.68
Jun 30 day = 65.10
July 31 Day = 67.27
Aug 4 Day = 8.68

Total Fee x total no of days= appeared in Starting to end month column.
Second i want to know how i assign a micro to a commond butten?
i have recorded micros just wnat to put