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.

Format(Month(dteDate), "00")

HTH,
Bernie
MS Excel MVP


"quartz" wrote in message
...
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.

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"quartz" wrote in message
...
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.