how to convert week number to month

  • Thread starter Thread starter frens
  • Start date Start date
F

frens

Hi,

how to convert a week number (say 43) to the corresponding month (sa
October)?

best,

Fren
 
What do you want to do when the week spans 2 months?

Regards,

Peo Sjoblom
 
Hi

What kind of week number (there are several ones, which vary by 1st day of
week and how 1st week of year is defined, used in different countries + the
one returned by Excel's WEEKNUM function) ?
For which year?
And as Peo sayd, sometimes the week belongs to 2 months. Moreover - the same
number of week can belong to different months in different years.


Arvi Laanemets
 
You must log in or register to reply here.

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

convert a number to month 6
Current month and the next two 1
How do I convert a number into years and months if the numberrepresents months? 5
Convert months to years/months 3
To detect month or days or year in if formula 1
I wanna show days and numbers automatically or with formulas 3
How to Convert MBOX to PST Online? 3
Convert value & symbols to just numbers 5

Back
Top