Message for Frank follow on Q from yesterday
 

Problem with IF and Nested IF
Morning Frank,
Not entirely sure what your after Frank; If one looks at Column A below I
want to convert them all into weeks format to standardise the data from the
different sources. Eg 6 Months and 182 Days (Col A) will become 26 Weeks, 28
Days will become 4 weeks follow this format for all the values in col A below.
12 months = 52 weeks, 90 days and 3 months = 13 weeks, 24 Months = 104
weeks, 4 months = 17 weeks, 36 months = 156 weeks.
Let me know if you need more info thanks once again for your help Frank
Ajay

Hi
could you email an example sheet

--
Regards
Frank Kabel
Frankfurt, Germany

"Ajay" schrieb im Newsbeitrag
...
Problem with IF and Nested IF
Morning Frank,
Not entirely sure what your after Frank; If one looks at Column A
below I
want to convert them all into weeks format to standardise the data
from the
different sources. Eg 6 Months and 182 Days (Col A) will become 26
Weeks, 28
Days will become 4 weeks follow this format for all the values in col
A below.
12 months = 52 weeks, 90 days and 3 months = 13 weeks, 24 Months =
104
weeks, 4 months = 17 weeks, 36 months = 156 weeks.
Let me know if you need more info thanks once again for your help
Frank
Ajay