# Brain Teaser!!!! Need Help

##### New Member
Hi All,
I need real help, I need a formula to calculate future date. The trick is the future date will depend on a couple of factors.
I am in recruitment, I recruit jobs and base them on categories
all jobs I work fall into 5 categories, 1-5 depending on how difficult they are to fill

Category 1 – takes 21 amount of days to hire
Category 2 – takes 35 amount of days to hire
Category 3 – takes 60 amount of days to hire
Category 4 – takes 84 amount of days to hire
Category 5 – takes 112 amount of days to hire

I want to calculate the start dates of each job I am working, depending on two things, what category it is, and where I am in the process with it, there are 4 stages to the process, Sourcing, Interview and Offer.
If a role is at Manager Meeting I want to add 63 days
If a role is at sourcing I want to add 63 days
If it is at Interview I want to add 42 days
If a role is at offer I want to add 35 days all to days date and the to the time it will take for the category.
In addition and if that wasn’t hard enough I want roles that are category 3-5 to have an extra week added to them when they get to interview stage, and subsequently offer stage.
Is this possible or does it make any sense to anyone!

### Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the \$ sign).

#### Wret

##### New Member
Make a list of your categories, roles, stages or other variables and assign them a value in days. Set up your worksheet with extra columns where you can add references to your variables. Then use a formula like =LOOKUP(A2,Sheet2!A:A,Sheet2!B:B)+LOOKUP(C2,Sheet2!A:A,Sheet2!B:B)+NOW() to calculate the date.

Replies
1
Views
248
Replies
0
Views
260
Replies
4
Views
159
Replies
6
Views
326
Replies
1
Views
213

1,190,809
Messages
5,983,042
Members
439,816
Latest member
aggelos

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back