## [Solved] Birthday spanks

### [Solved] Birthday spanks

OK, I think this is one of the weirdest questions I've been asked to solve, and I know how to do it the long way, but was wondering if there was a formula to calculate this.
Specifically the number of birthday spanks a person would have received by a certain date.
Eg: Person born Feb 10 1965 would have received X birthday spanks (presuming from one person) by Feb 10, 2020 (ie: 55th birthday).
The long way of doing this, if I'm not mistaken, would be
Code: Select all   Expand viewCollapse view
`=45*5+100*(1+2+3+4)+50*6+1+2+3+4+5`
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.

RusselB
Moderator

Posts: 5854
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

### Re: Birthday spanks

That's a custom I've not heard of before; but a quick web search enlightened me

According to StackExchange you can do this - summing n consecutive numbers - as follows.

Take the average of the first number and the last number, and multiply by the number of numbers.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine

robleyd
Moderator

Posts: 3145
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

### Re: Birthday spanks

Thanks. I tried to do a web search but guess I was using the wrong terms, as I was either getting nothing or millions of responses... and I didn't want to try looking through that.
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.

RusselB
Moderator

Posts: 5854
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

### Re: [Solved]Birthday spanks

You're welcome. I used the Duck with the term calculate sum of n successive numbers formula but should have used consecutive instead of successive; however I got the answer.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine

robleyd
Moderator

Posts: 3145
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia