125 reputation
7
bio website n/a
location Wales, United Kingdom
age 29
visits member for 3 years, 5 months
seen Jul 30 at 7:52

Im Mark, I live in Wales, UK


Sep
14
awarded  Popular Question
Apr
15
accepted WinSCP: copy changes to multiple servers
Nov
27
awarded  Supporter
Nov
27
comment WinSCP: copy changes to multiple servers
Drop box is out of the question due to security. I like your answer, but im going to wait and see if anyone has anything slightly more "ready to go"
Nov
21
asked WinSCP: copy changes to multiple servers
Jul
31
asked Is there a way to remove stationery from incoming mail messages in outlook 2007?
Dec
30
awarded  Autobiographer
Aug
25
awarded  Scholar
Aug
25
accepted Excel / open/libre office formulae: number of full months left until date
Jun
9
awarded  Student
May
18
awarded  Tumbleweed
May
11
asked Reduce font size of incoming mail in Outlook 2007
Mar
14
comment Excel / open/libre office formulae: number of full months left until date
is this LibreOffice specific? MS-excel doesnt like it. I will try it in LibreOffice when I get home.
Mar
14
comment Excel / open/libre office formulae: number of full months left until date
your formula uses 3 inputs. I only have 2 (or 1 if you include a formulae to grab the current date). In my question I talked about the 13th and 17th because, if the input is one of those the answer should differ, just as you have done there, but with only a single constant date variable and a variable for todays date
Mar
14
comment Excel / open/libre office formulae: number of full months left until date
Im after the number of full months left to the date +1 if there is any remainder? I guess an easier way of explaining this would be "how many paydays left until the date in P1? if payday is the 16th day of the month"
Mar
14
comment Excel / open/libre office formulae: number of full months left until date
That works nicely on month, but does not take into account days. In this example on 2011-03-13 the answer would equate to 8 on 2011-03-17 the answer would equate to 8 still, but should be 7
Mar
14
awarded  Editor
Mar
14
revised Excel / open/libre office formulae: number of full months left until date
edited body
Mar
14
comment Excel / open/libre office formulae: number of full months left until date
sorry. I meant to do it in international format so as not to confuse anyone YYYY-MM-DD. but messed up. - normally I do it the british way DD/MM/YY - but that will probably confuse many americans out there. I shall correct.
Mar
13
asked Excel / open/libre office formulae: number of full months left until date