Excel: Formula based on dates

Hi there, I've got a spreadsheet where the start date is amendable and this is what I wanted. E.g. start date is Jun-14 and I want the formula to to calculate annual salary divided by 12 in each month from June onwards until Mar-15 (Financial year is April to Mar) and the same way to not show anything in April or May as they started in June... How can i achieve this please as I tried IF statements and it doesn't recognise dates and years... Thanks! Anu

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of August 06, 2014.

For more resources for Microsoft Excel