I need a way to convert a text field to number of days. Can this be done easily?
The entries look like this:
1 year 3 weeks
1 month 2 days
2 years 4 months
3 weeks 1 day
2 years 7 months
1 week 3 days
3 months 1 week
etc.
Nice question ("
frowning")
Easily?
I have a few questions of my own.
How important is it to know which year? Leap years will influence reporting? Does your sheet have a column to report that?
Assumedly the Year will begin from 1 January?
Similarly the length of months can be 28,29,30 or 31. Therefore, when dealing with one month, can that be detected? With several months can the start month be detected?
Again, I assume that a week will be from Sunday, and therefore 7 days.
Depending upon your answers I'm thinking that a macro would be the only way. That said, if your sheet had columns like:
Start Year, Start Month, someone might be able to produce a formula which could be copied down your No. of Days column.
Hope that gives some guidance.