how do i select which data to use depending on the date?

R

RJinNZ

I need a function that will let me work out how much of an amount to cover
certain date ranges.
I would like to be able to enter any two date ranges eg 1.01.09 and 1.01.12
and use this information to work out the proportion of a salary that is
covered by this range.
the fixed data would be that the salary is $140,000, until 1.06.09 when it
would change to $160,000, and from 1.06.10 salary would be $180,000.
I have been using an IF function and subtracting one date from the other but
it is not working as I get stuck when I put in a start date that occurs after
1.06.09 (the first increase) and also working out how to end the calculation.
I am trying to work out the total salary paid over the given range of dates.

Help would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
How to use/create code in MS Word to calculate age? 0
Add Values that Match 2 Criteria Q 1
I figured out the issue thank you. 0
Macro to Select text from a point given to a specific word 2
How to Select Multiple Emails using Surface Pen 0
sumif issues 1
Calculating Salary based on Date Range 2

Top