|
Aug 2011
5:18pm, 30 Aug 2011
4,643 posts
|
Stander
is there something strange with forum posts containing the character <
|
|
Aug 2011
5:19pm, 30 Aug 2011
4,644 posts
|
Stander
Yes there is.
The last character missed from post above was the less than character.
|
|
Aug 2011
5:20pm, 30 Aug 2011
20,404 posts
|
John66
A1 has 25/6/2010 (start date)
B1 has 24/6/2013 (end date)
C1 has 1095 (B1-A1)
I want D1 to have no of relevant days in 2009 (Answer = 0)
I want E1 to have no of relevant days in 2010 (Answer =189 )
I want F1 to have no of relevant days in 2011 (Answer = 365 )
I want G1 to have no of relevant days in 2012 (Answer = 366)
I want H1 to have no of relevant days in 2013 (Answer = 175 )
I want I1 to have no of relevant days in 2014 (Answer = 0)
|
|
Aug 2011
5:21pm, 30 Aug 2011
3,227 posts
|
bigleggy
Stander - think it's a security measure to stop people trying to hack the site - your formula, whilst harmless, would have looked suspiciously like HTML and the security would have supressed it
|
|
Aug 2011
5:24pm, 30 Aug 2011
4,645 posts
|
Stander
if(a1 [less than] 40179,0,40544-a1)
returns a value of 0 for all dates before 01/10/10 (value 40179).
For dates after 31/12/09 but before 01/10/11 it returns a value equal to the number of days within 2010
Is what I was trying to type.
|
|
Aug 2011
5:25pm, 30 Aug 2011
4,646 posts
|
Stander
Next cell would use values 40544 and 40909 for 2011, etc, etc, etc
|
|
Aug 2011
5:27pm, 30 Aug 2011
13,085 posts
|
Stumpy
insert appropriate number of columns (3 in this case) and have an end date of 31st december for the years 2010 - 2012. if it will always be a similar number of years that the grant covers. just call them year one, year 2 etc.
then you can do it as simple subtractions. if you want one you can update with any year i'd have to have a bit of a think. if i had excel in front of me i could probably mock it up that you would only have to put in a start and end date the others would come up automatically. but i don't. sorry.
and if you use the less than character on the forum here, just make sure you put a space after it and it should be fine and will stop all text after it disappearing.
|
|
Aug 2011
5:29pm, 30 Aug 2011
10,254 posts
|
JohnnyO
I would ask my secretary to sort it out.
|
|
Aug 2011
5:36pm, 30 Aug 2011
13,086 posts
|
Stumpy
LOL! 
|
|
Aug 2011
6:00pm, 30 Aug 2011
20,405 posts
|
John66
Thanks for help - sadly I'm none the wiser. I've emailed Stander for further assistance.
|
