Change Month formula from column to column
 

I am sure this is an elementary question, but am really short on time to
research. How can I start with July-07 in A1 and in B1 show August-07? I
should also state that I have another spreadsheet that is looking in A1 for
the date format of 1/1/07 and in B2 as 8/1/07 etc...it's a process that
already exists but I want the Month-Yr format as stated above. Thanks for the
help!

Change Month formula from column to column
 

Set A1 to July date, B1 to Aug date, highlight both cells and copy across as
required.

"Jana" wrote:

I am sure this is an elementary question, but am really short on time to
research. How can I start with July-07 in A1 and in B1 show August-07? I
should also state that I have another spreadsheet that is looking in A1 for
the date format of 1/1/07 and in B2 as 8/1/07 etc...it's a process that
already exists but I want the Month-Yr format as stated above. Thanks for the
help!

Change Month formula from column to column
 

Cutsom Format as "mmm-yy"

"Jana" wrote:

I am sure this is an elementary question, but am really short on time to
research. How can I start with July-07 in A1 and in B1 show August-07? I
should also state that I have another spreadsheet that is looking in A1 for
the date format of 1/1/07 and in B2 as 8/1/07 etc...it's a process that
already exists but I want the Month-Yr format as stated above. Thanks for the
help!

Change Month formula from column to column
 

Worked! Thanks so much for the help!!!! I love this website!

"Jana" wrote:

I am sure this is an elementary question, but am really short on time to
research. How can I start with July-07 in A1 and in B1 show August-07? I
should also state that I have another spreadsheet that is looking in A1 for
the date format of 1/1/07 and in B2 as 8/1/07 etc...it's a process that
already exists but I want the Month-Yr format as stated above. Thanks for the
help!