Find month name from week number

[neha_sri]

Hi,

I have week number and I want to calculate month name from it.Can I do so...

[Anonymous]

You can, but week number is not enough.

First, week may belong to two months, so you need to tell what day of the week defines the month - Monday, or Sunday, or....

Second, you need to know the year.  Same week number could be in different months in the different years.

[alematex]

=MakeWeekDate(2014,34)

returns last monday

[alematex]

MakeWeekDate(2014,34,3)

returns thursday 0-Monday 6-Sunday

[MarcoWedel]

Hi,

using a combination of MakeWeekDate and MonthName delivers the month name:

=MonthName(MakeWeekDate(Year, Week))

hope this helps

regards

Marco