Extract Year/Month (for grouping/reporting)

In Excel when you want one column to contain the year-month (for grouping purposes) -- here is the formula

=TEXT(A2,"yyyy-mm")

That text formula sure looks handy.

If you don't know about pivot tables, then you should. Pivot tables are worth your time.

results matching ""

    No results matching ""