One Cost Divided Among Multiple Date Ranges
Hi,
If I understand correctly, you would be better off :
1. having a count formula which takes care of the exact number of
months
2. dividing your cost total by this number for each month
3. using If function only to determine if the respective month is
available or not
HTH
Cheers
Carim
|