CPIU

CPIU returns the Consumer Price Index for All Urban Consumers (CPI-U), as published monthly on the internet, and can be downloaded from the BLS web site via the “Special Menu”.

· Inflationdata.com

· U.S. Bureau of Labor Statistics (U.S. city average, All items - CUUR0000SA0)

CPI-U is used to annually adjust the IRS limits. For more information, see function IRSCOLA.

Syntax

CPIU (Year, [Month])

Parameter Name

Description

Year

Year: a 4 digit number. Or instead of entering a year, you can enter a date as “m/d/y”, and if you omit the Month parameter, then Year = “y”, Month = “m”, and “d” is ignored.

Month

Month as a number or a 3-letter abbreviation; or “annual”, “half1”, “half2”:

Mo	Description
"jan" or 1
"feb" or 2
"mar" or 3
"apr" or 4
"may" or 5
"jun" or 6
"jul" or 7
"aug" or 8
"sep" or 9
"oct" or 10
"nov" or 11
"dec" or 12
"annual" or 13	average of all 12 months in Yr
"half1" or 14	average of 6 months January through June in Yr
"half2" or 15	average of 6 months July through December in Yr

Optional; default = “annual”.