CPIW

CPIW returns the CPI Urban Wage Earners and Clerical Workers (CPI-W), as published monthly on the internet, and can be downloaded from the Social Security web site via the “Special Menu”.

· Social Security Administration

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

CPI-W is used to annually adjust Social Security benefits. For more information, see function SSCOLA.

Syntax

CPIW (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: a 3-letter abbreviation, or a number:

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”.