Formula To Convert Months Into Weeks

[crusader]

Hi,

I'm having an issue converting months into weeks. My example is I have people who must provide leaving notice (could be months or weeks). For instance column B details months, and column C details weeks. I'd like to convert months (column B) into weeks in column D, but am not sure of the components of such a formula so I won't list or guess as I'm just not sure.

Your help is greatly appreciated.

Crusader

[shg]

Your question is not clear at all. Can you post an example workbook and explain in context?

[Dave Hawley]

The Month January etc would "convert" to Week?????

If you mean Week Number see the WEEKNUM Function.

[great_big_bear]

Converting months to weeks really depends on the definition of months according to your co. I know accountants who live 48-week years. (Which I would say is just living too fast).
So, if a month is four weeks:
week value = month value * 4
4 months = 16 weeks

If a month is 30 days:
week value = month value * (30/7)
4 months = 17.14 weeks

If there are 52 weeks in a year:
week value = month value * (52/12)
4 months = 17.33 weeks

If there are 365.25 days in a year:
week value = month value * (365.25 / 12 ) / 7
4 months = 17.39 weeks

Hope this helps

[crusader]

apologies for not being clear. I attach an excel example of what I'm trying to achieve.

In column A, I present a number of people; column B, the notice period those people must provide when resigning their post (in months); column C, the notice period those people must provide when resigning their post (in weeks); in column D, I'd like to automate this function by writing a formula that give me the following:

=if(b2>0,[?X?],C2)

where [?X?] converts the number of months leave into weeks i.e. 3 months notice = 12 weeks leave (roughly speaking). Is there a (combination of) function/formula that will calculate this for me?

[great_big_bear]

Also, logically, wouldn't you prefer to "if test" for the week value, which will definitely be accurate in weeks and only return the converted month value in the absence of a week value?

I mean =if(c2<>0,c2,[x?x])

If both are entered presumably you'd want to display the week value as entered...