roscoe
Well-known Member
- Joined
- Jun 4, 2002
- Messages
- 1,062
- Office Version
- 365
- Platform
- Windows
- MacOS
Trying to build lookup table for Social Security benefits based on birthday and date to start receiving benefits. The SSA table shows the age of the claimant in a string format such as "67 + 3 Months".
The date is generated by subtracting the birth date from the claim date. I had a string generator that worked perfectly...until I picked a claim date whose month was earlier than the birthdate (i.e. claim in July but the birthdate is in Oct). The resulting string was "66 + -3 months" which should really be "65 + 9 months". Maybe it's late, but I'm stumped. I thought I'd try a custom function but I'm getting nowhere (no matter how simple I create a test function I get #NAME? as the result. I've built user-defined functions before (granted I'm rusty) but this shouldn't be this hard...
Any help would be appreciated
The date is generated by subtracting the birth date from the claim date. I had a string generator that worked perfectly...until I picked a claim date whose month was earlier than the birthdate (i.e. claim in July but the birthdate is in Oct). The resulting string was "66 + -3 months" which should really be "65 + 9 months". Maybe it's late, but I'm stumped. I thought I'd try a custom function but I'm getting nowhere (no matter how simple I create a test function I get #NAME? as the result. I've built user-defined functions before (granted I'm rusty) but this shouldn't be this hard...
Any help would be appreciated