Excel for hiring new people - based on yearl salary but months

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

solved

Post Body

Hi there,

I know the title sounds a bit confusing. I have to do a HR forecast and I made a table that looks like this:

https://preview.redd.it/f6vhj6h25lic1.png?width=321&format=png&auto=webp&s=54d396d9a5182cbd4b41ae1c776e7857fa713873

So basically, we're planning to hire Software Developers and the median salary in our city is 77k. We want to hire 1 in July, 1 in Oct and 1 in Nov. To get the yearly expenses I just used the formula: =SUM(E17:E28)*E13. But this is not right, as we won't pay the whole salary to the person that starts, lets say, in November - I think this is really an easy solution but I just can't think of a way right now to solve this.

I'd appreciate any help. Thanks!

Author

Account Strength

100%

Account Age

9 years

Verified Email

Yes

Verified Flair

Total Karma

14,582

Link Karma

9,016

Comment Karma

5,389

Profile updated: 5 days ago

Posts updated: 10 months ago

tomatoesarelife

Subreddit

r/excel

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 11 months ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/excel/comme...