sychoangel
Registered User.
- Local time
- Today, 13:23
- Joined
- Jul 4, 2008
- Messages
- 20
I am running around in circles and not getting anywhere...
I am trying to put together a formula that looks at a date &
-if the date is in the current month (i.e. Mar 2014) it returns a 0
- if the date is in the last 13 months (i.e. between Feb 2013 & Feb 2014) it returns a 1
- if the date is > 13 months (i.e. Jan 2013 & prior) it returns a 0
I then can use this to build pivot tables for a monthly report that shows a rolling 13 month chart of the data... the report is easy but I am really struggling getting the formula right
E.g. of data & result required
01 Mar 2014 0
12 Feb 2014 1
11 Nov 2013 1
28 Feb 2013 1
01 Jan 2013 0
I am trying to put together a formula that looks at a date &
-if the date is in the current month (i.e. Mar 2014) it returns a 0
- if the date is in the last 13 months (i.e. between Feb 2013 & Feb 2014) it returns a 1
- if the date is > 13 months (i.e. Jan 2013 & prior) it returns a 0
I then can use this to build pivot tables for a monthly report that shows a rolling 13 month chart of the data... the report is easy but I am really struggling getting the formula right
E.g. of data & result required
01 Mar 2014 0
12 Feb 2014 1
11 Nov 2013 1
28 Feb 2013 1
01 Jan 2013 0
Last edited: