# 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

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

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

Replies
15
Views
166
Replies
7
Views
301
Replies
13
Views
241
Replies
1
Views
43
Replies
0
Views
132

1,171,881
Messages
5,878,035
Members
433,312
Latest member
SilentSam

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