Changing Dates to Days

[danielbarker1975]

Good evening. I have a table of data where the month and days are provided like:

2 M 14 D

I need to convert this to number of days, assuming the month is 30 days, so for the above would be 74

Grateful if your clever minds can help.

Thanks

[danielbarker1975]

Sorry i should add the format changes so could be
3 M 13 D
4 M 12 D
4 M 22 D
4 M 1 D

[cubangt]

is that data in separate columns or all in the same column/cell
If it is like the attached pic, try this formula (assuming you will always use 30 days)

Please Login or Register  to view this content.

copy down.

[Aardigspook]

If your data is all in one cell, formatted as number of months-space-M-space-number of days-space-D then you can use this:

Please Login or Register  to view this content.

Edit: the above assumes that the number of months will not be more than two digits. If you could have more than 99 M, use this instead:

Please Login or Register  to view this content.