Return double digit month

quartz · 04-04-2005, 11:06 AM

Is there a way to return a two digit month using the MONTH function? i.e. 01,
02, 03, 04, etc.

For example, when I try: Format(Month(dteDate), "MM")

It does not return the correct month...how can I get at this? I'm sure I
know how to do this, but it's a Monday and I'm dragging...

Thanks much in advance.

**jindon** · 04-04-2005, 11:36 AM

try

Please Login or Register  to view this content.

" & ' followed by 00"

Bernie Deitrick · 04-04-2005, 12:06 PM

Format(Month(dteDate), "00")

HTH,
Bernie
MS Excel MVP

"quartz" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to return a two digit month using the MONTH function? i.e.
01,
> 02, 03, 04, etc.
>
> For example, when I try: Format(Month(dteDate), "MM")
>
> It does not return the correct month...how can I get at this? I'm sure I
> know how to do this, but it's a Monday and I'm dragging...
>
> Thanks much in advance.

Niek Otten · 04-04-2005, 12:06 PM

If dteDate is a real date, just use Format(dteDate,"mm")

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"quartz" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to return a two digit month using the MONTH function? i.e.
> 01,
> 02, 03, 04, etc.
>
> For example, when I try: Format(Month(dteDate), "MM")
>
> It does not return the correct month...how can I get at this? I'm sure I
> know how to do this, but it's a Monday and I'm dragging...
>
> Thanks much in advance.

**allenneukomm** · 09-20-2017, 04:29 AM

Hi all,

I am trying to do the same thing and have the following code:

Please Login or Register  to view this content.

However when I step into the Sub and hover the mouse over Month it shows Month = " "
Does anyone know where I am going wrong? I'm using Excel 2016

Thanks and best,
Allen

**meabrams** · 09-20-2017, 04:48 AM

@ allenneukomm Next time please start a new tread so you are not taking over another members thread.... with that said

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**allenneukomm** · 09-20-2017, 04:56 AM

Excellent thanks! That did it!

**alansidman** · 09-20-2017, 05:05 AM

@allenneukomm
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too. Please read our forum rules and comply in the future.