Convert text to number of days

[erahi]

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.

 

[Rick Rothstein]

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.

The problem with your request is you have months in there... that makes the answer dependent on the starting starting date given that the number of days within the months which, in turn, means there is no solution to your problem given the information you have provided.

 

[BrianJN1]

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.