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