Converting date value

[geo40]

A short one;

If I have date value 17/08/2005. With which formula do I get the date notation:

(1) 08-2005 ( month-year )
(2) 03-2005 ( quarter-year )

Regards,

GEO40

 

[AnotherHiggins]

Have you had a look at Excel's help file? I don't mean to be rude, but please keep in mind that this is not a help desk. You are expected to try to find answers on your own before posting questions.

If you have already tried anything, please tell us what it was. Getting the date to display as "08-2005 ( month-year )" is dead simple and you should find out how to do it by using Excel's help file.

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

... and I also notice that you have posted for the past several years without ever acknowledging a "[blue]valuable post![/blue]"

Neither this fact nor your failure to pursue available means of help, reflect well on you.

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[xlbo]

There is no formula you need - all you need is to FORMAT the cell as you wish

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question