Dear Max
Thank you, great help and highly appreciated.
It really solve my problem. I need one more help in this excel sheet. I want
to insert some empy rows and colum in begnning. But when I insert rows colum,
the formula be come wrong #Value!. Please tell me how I insert rows and
colum
"Max" wrote:
Put instead in F2:
=IF(AND(DATE(YEAR(F$1),MONTH(F$1),1)=DATE(YEAR($B 2),MONTH($B2),1),DATE(YEAR(F$1),MONTH(F$1),1)<=DAT E(YEAR($C2),MONTH($C2),1)),$D2/(DATEDIF($B2,$C2,"m")+1),"")
Copy F2 across and fill down to populate the table
Pl keep discussions within the newgroup for the benefit of all.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
--- Ahamd N wrote:
Dear Max,
Thank you to help me it highly appreciated,
I have one problem with this file.
If one person came in May 3rd (for one month his membership will expire in
Jun 3rd.) when I entered revenue it goes to month of Jun (nest month) not
current month it should go to current month, in month of May not next month..
Current month must get it revenue. Even member come any date of the month
first to last day of the month. Please correct the formula which show revenue in
current month, and if member ship more then one month the revenue should
go to coming months.