# Training frequencies - 1 year = 365 days

#### mykeee

##### New Member
I am working on my company's training tracking spreadsheet and I've run into a bit of a stumbling block.

I know I am probably missing something very simple here but this is what I need help with.

Some of the training we administer has a required frequency of every 1 year, 2 years, 3 years, etc. Now I have created a drop down list to select the appropriate frequency. In the cell next to it I would like to have it calculate the number of days (ex 1 year = 365 days). I need that value so I can calculate the date the employee needs to be retrained (their training date plus one year). I can't figure out how to get it to calculate this. My year list returns a text value "1 year" otherwise I would just multiply that cell by 365. Any ideas?

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### CROY1985

##### Active Member
try this:

=LEFT(N2,FIND(" ",N2)-1)*365

where n2 is your cell with "1 year".

#### Steph77

##### Board Regular
Try =VALUE(TRIM(LEFT(D2,2)))*365

(changing D2 for wherever your text is of course)

#### Steph77

##### Board Regular
You might also like to use something like this:

You wouldn't have to multiply by 365 that way and I think it would automatically adjust for leap years (but not 100% sure on that point)

#### mykeee

##### New Member
Thanks everyone! That worked great!

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,167,815
Messages
5,855,791
Members
431,764
Latest member
scottishbigyin

### 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.

### Which adblocker are you using?

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

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