Defining Range within Specific Dates

C

Cardan

Hello all,

I am having a problem which may be simple to some. I working on
financial analyis model and I have a cost item that needs to be sprea
out over a certain amount of consecutive months (it can be either
months, 4 months, etc..) This cost can also start in any month. I a
having trouble defining the range for this formula. Whenever I use a
IF function it does not let me specify the range, only the first mont
or the last month. I am using EDATE for my monthly headers and t
calculate the range in months. Any suggestions? Thank
 
Top