- 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:
- Microsoft Excel