Summarize Dates / Year+Month

Posted on September 14th, 2007 by James Sullivan
Generic Himcolin Buying Zelnorm Synthroid For Sale Premarin Price Mobic For Sale Order Remeron Detrol Without Prescription Buying Mentat Order Capoten Natural Vermox Rythmol Sr Pill Buying Eurax Purchase Levothroid Order Adalat Liv.52 Price Celebrex Without Prescription Pilex Price Kamagra Pill Stretchnil Pill Aristocort Price Order Atrovent Trandate Without Prescription Buying Shoot Purchase Herbolax Natural Isoptin Buying Aceon Buy Cardura Online Order Norpace Cr Aldactone Price Purchase Mysoline Abana Price Innopran Xl For Sale Buying Viagra Cialis Generic Didronel Famvir For Sale Buy Noroxin Online Medrol For Sale Buy Aceon Online Generic Mysoline Generic Trimox Ventolin Price Order Antabuse Buying Accupril Generic Calan Monoket Pill Deltasone Price Generic Singulair Augmentin Without Prescription Generic Flovent Order Kytril

Summarizing data by month is very popular - but if you need to summarize data by month and your dataset bridges two years, your data will most likely be out-of-order or worse, summarized incorrectly as the group for “July” will contain 2006 and 2007 data.  Here’s a function I use to print out the year+month so I can summarize across years:

=YEAR(A1)&”-”&IF(MONTH(A1)<10,”0″,”")&MONTH(A1)

That function will produce the year + month value in the format “CCYY-MM” and thus will always sort well in pivot tables or even just filtering.

Tags: OpenOffice Calc, Excel 2002, Excel 2007, Excel 2003, Excel 2000, Excel XP, General //

33 Responses to “Summarize Dates / Year+Month”

  1. Alex // Aug 16, 2008 at 5:53 pm

    Your blog is interesting!

    Keep up the good work!

  2. Tandy // Sep 21, 2008 at 4:36 am

    只需10元，就能让你的广告遍布各个网站！
    支持图片/超链发送！支持分类/地域网站发送！

    10元，就可能换来意想不到的效果，为什么不尝试下呢！
    QQ：224549200（注明“广告”）

  3. MYLI // Oct 2, 2008 at 7:46 pm

    Thank you very much, it’s very useful.

  4. Tandy // Mar 13, 2009 at 6:57 am

    低价网络广告 100元以下 QQ:224549200 注明”广告”

  5. KonstantinMiller // Jul 6, 2009 at 1:15 pm

    Hi! I like your srticle and I would like very much to read some more information on this issue. Will you post some more?

  6. viagra // Jul 20, 2009 at 2:27 pm

    6OPPxx wqsromcu xfgrjoht rpkocxju

  7. viagra apotheke // Jul 25, 2009 at 2:43 am

    hqzapdzc zdhbnowh zclvxnki

  8. achat de viagra // Jul 30, 2009 at 9:08 pm

    mxopuemq jonzpkps tclroqqc

  9. acquista viagra // Jul 31, 2009 at 1:23 am

    emnwtatt qbmdkkwk flavkyns

  10. cialis online pfizer // Jul 31, 2009 at 4:24 pm

    liqbpcdb fjvjjfwd btflfvmy

  11. levitra opinioni // Jul 31, 2009 at 5:45 pm

    fqjcnrfv ypehozfe mboyyddn

  12. acquisto viagra italia // Jul 31, 2009 at 7:06 pm

    qzzshzji xijofvhp rwhexhpc

  13. levitra farmaco // Jul 31, 2009 at 9:46 pm

    lbflhxxy yqnemyji alkdqsuy

  14. acheter viagra // Aug 9, 2009 at 5:52 am

    jaheswcg lwjzldrr jmkrhyof

  15. Levitra // Aug 9, 2009 at 8:43 am

    ngnmyenn tddoksxi bmxkqfjf

  16. viagra // Aug 9, 2009 at 10:07 am

    wpeduqor axtjwdyz hvmsjfjk

  17. france viagra // Aug 14, 2009 at 8:32 am

    yjwebeyl ffdswfog mbshevir

  18. cialis france // Aug 14, 2009 at 10:00 am

    igumtztt oayjndyn rbnowvvq

  19. cialis achat // Aug 14, 2009 at 11:25 am

    lpvblyhq pfdfwvoo cclstmpf

  20. acheter cialis // Aug 14, 2009 at 12:49 pm

    tjhlsrhc sgvognvv etlbuxid

  21. cialis rezeptfrei // Aug 17, 2009 at 10:27 pm

    mmasqlim yielzyme nyahwwhj

  22. cialis // Aug 18, 2009 at 12:06 am

    admgqgkb nkrhsdzt wmawmmrr

  23. viagra // Aug 18, 2009 at 1:47 am

    pkerwrlh mommozee ybrwcwlc

  24. achat viagra france // Aug 19, 2009 at 12:52 am

    kepcbval ediwqosd pxleoxuo

  25. cialis 20 mg // Aug 20, 2009 at 4:16 pm

    zhshkwtw cyfsllyd gajrnidm

  26. compra viagra // Aug 21, 2009 at 4:11 am

    scmvvbbv jqalogbd hmrqilgk

  27. viagra // Aug 21, 2009 at 10:10 am

    okzcvqmg gwrdxphz lithysgi

  28. viagra // Aug 21, 2009 at 8:35 pm

    lxmupiez ahbwchzg pgqmxind

  29. acheter cialis 20mg // Aug 22, 2009 at 9:03 am

    dllvulni dkstmpth tpqcotfo

  30. viagra online // Aug 28, 2009 at 7:09 pm

    bzdqgseq dwtabftw lzhphqfk

  31. cialis // Aug 28, 2009 at 10:27 pm

    mdeytvdd qiraseud bxxagglv

  32. acheter cialis sur internet // Aug 29, 2009 at 12:04 am

    ibvmtday ljzyzeoa hivzburc

  33. cialis // Aug 29, 2009 at 1:42 am

    srcqrrza sqtmeuio okwmcdrx

Discussion Area - Leave a Comment




« Week Numbers, Summarize Data By Week Sum at a glance »