Message for Frank follow on Q from yesterday

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with data using IF and Nested IF statements possibly??? 2
Name The Week Of The Month 7
Automatic changing refrences to sheet corresponding to first day. 16
I have run out of arguments for nested IF statement 5
What are the alternatives ??? 4
How to have data labels follow time adjusting line charts? 0
(Part 2) - Retrieve Numeric Label for Max Value by Specific Day & Month 4
Does VBA support flattening/serializing to "binary" string? 6

Back
Top