Matthew has attended:
Excel VBA Intro Intermediate course
Spliting out Costs between date ranges
Hello,
I am trying to create a worksheet that splits out the cost of a resource of the duration of a task based on the company I work for financial year.
The is I am have is when a task starts or finish part way through a year. The formula I am using adds the whole years cost rather than part of year.
The formula I am using is.
=MAX(0,IF(AND(K$5>=$E8,L$5<=$F8),K$4*$H8,(K$4-(L$5-$F8))*$H8))
I can email the workbook if needs be to make it easier to understand what I am trying to achieve.
Thank you in advance.
Matt
RE: Spliting out Costs between date ranges
Hi Matthew,
Thank you for the forum question.
Yes your question will make more sense if I can see the worksheet.
Please send it to:
jens.bonde@stl-training.co.uk
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Spliting out Costs between date ranges
Jens,
I emailed the workbook across to you this morning. Hopefully now you will have a better understanding of what I am trying to achieve.
Regards,
Matt
RE: Spliting out Costs between date ranges
Thanks Matthew,
I am training today but I will have a look at it tonight.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
