How long a Co2 canister will last depends on how frequently you use it. People who drink about one 8-ounce glass of fizzy water a day can expect their canister to last for 2-3 months.
If you drink sparkling water more often, say 8 ounces twice a day, it will only last for about a month.