ReneeHansen1

7 months agoQrew Cadet

# Formula Help

I need to calculate a couple of things for the cost of a resource

The first year costs, but each "start date" is different. and the year end needs to be 12-31-[whatever year the start date year is].

I have requested start date, # of months they're needed.

So for instance if a resource is requested to start on April 1, 2024, and they're needed for 60 months, and they're monthly costs are $1,000

What is the end date, if they start on April 1st and are needed for 60 days?

What is the cost for that first year if they start on April 1st and go to the end of the year (of whatever their start year was)

Thanks!

I also need a formula for

------------------------------

Renee Hansen

------------------------------