for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

Prev
1
2
3
4
5
Next
Last

Stander Aug 2011 5:18pm, 30 Aug 2011 4,643 posts	Quote Pin Stander is there something strange with forum posts containing the character <
Stander Aug 2011 5:19pm, 30 Aug 2011 4,644 posts	Quote Pin Stander Yes there is. The last character missed from post above was the less than character.
John66 Aug 2011 5:20pm, 30 Aug 2011 20,404 posts	Quote Pin 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)
bigleggy Aug 2011 5:21pm, 30 Aug 2011 3,227 posts	Quote Pin 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
Stander Aug 2011 5:24pm, 30 Aug 2011 4,645 posts	Quote Pin 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.
Stander Aug 2011 5:25pm, 30 Aug 2011 4,646 posts	Quote Pin Stander Next cell would use values 40544 and 40909 for 2011, etc, etc, etc
Stumpy Aug 2011 5:27pm, 30 Aug 2011 13,085 posts	Quote Pin 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.
JohnnyO Aug 2011 5:29pm, 30 Aug 2011 10,254 posts	Quote Pin JohnnyO I would ask my secretary to sort it out.
Stumpy Aug 2011 5:36pm, 30 Aug 2011 13,086 posts	Quote Pin Stumpy LOL!
John66 Aug 2011 6:00pm, 30 Aug 2011 20,405 posts	Quote Pin John66 Thanks for help - sadly I'm none the wiser. I've emailed Stander for further assistance.