Most valuable professional
  • Hot Topics

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 Last edited by anum; Aug 6th, 2014 at 08:47 AM.

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

This thread is current as of August 6, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel