Hi everyone,
i have a given start date, lets say 05/01/12
Now, i want new columns named after the start date + 6 month.
f.e.
column1 | column2 | column3…
05/01/12 | june | july | august | september | october | november
07/01/12 | august | september | october | november | dezember | january
I hope that makes sense :)
From my point of view, it cant be that hard :D . I tried with several workarounds like creating arrays but then the sorting of the months is messed up.
btw. How do exclude empty values from an array created via NP(join) so that he only looks at "a", "b","c","d" when I split the array (;;;a;b;c;d;;) with NP(split)?
Any Ideas?
BR
Michael
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment english is ok for me as long as you understand me ;).
Meanwhile I found a solution which is complicated but works.
I attached a sheet, which hopefully explains my problem/ question better.
Is there a less complicated way to do this? -
Jet Reports Historic Posts Hi Michael,
Is this what you are looking for?- Cell D3 Period start 1-5-2012 (May 1, 2012) - Cell E3 =EOMONTH($D$3;1) - Cell F3 =EOMONTH($D$3;2) etc.
Then you can use Format Cells on Cell F3 etc to select Custom format and then enter "mmmm" as the format to generate the name of the month.
I hope this makes sense too :) Und fur mich wird es auch kein Problem sein wenn Du es auf Deutsch erklaren mochtest. -
Jet Reports Historic Posts Aha! Thanks for the example! I think I got it now.
Have a look at the attached example. Would that work for you? -
Jet Reports Historic Posts Thats It. Thank you. Definitely simpler then my solution :D
Please sign in to leave a comment.