December 31, 2019
Would REALLY appreciate some help with this. I am trying to extrapolate some sales projections from data which requires converting a column which contains a time period. The issue is that the time periods are mixed, eg 1 week, 3 months, 17 weeks, 23 months etc.
What's the fastest way to convert this column to something I can then use in a formula?
This is an urgent query. THANKYOU!
December 20, 2019
How about this in column D, gives you the number of days
Weeks is fairly easy, but months you would need to work out the number of days 28, 30 or 31 - you can change the 30 at the end
Let me know if it suits
June 25, 2016