Month and year problem -
 

Hi there I have a slight problem and I don't know how to do it.

I have these 3 columns in:

Column A (January to December in a sequence) around 170 cells

Column G has a calendar that pops up and displays dates (format dd/mm/yyyy)
(this is only filled in if actions are required)

Column H that has dates in it in same dd/mm/yy format (only filled in
automatically if they have looked at the cells)

What I need it to do is if cells in column G & H are blank then it keeps the
cells going in the same sequence down as it is already (but as Jan-07 format
for example)

If column G has input e.g. 31/04/07 then it changes column A to the
following month e.g. May-07.

And if column H has been filled in then it will change the date in A to a
year after the date it originally had e.g. May-07 will become May-08.

G will always take precedence over H if both are filled in.

Any help with this would be greatly appreciated as I am a complete novice at
the moment.

Month and year problem -
 

IGNORE THIS - FIGURED IT OUT.

"Pasty" wrote:

Hi there I have a slight problem and I don't know how to do it.

I have these 3 columns in:

Column A (January to December in a sequence) around 170 cells

Column G has a calendar that pops up and displays dates (format dd/mm/yyyy)
(this is only filled in if actions are required)

Column H that has dates in it in same dd/mm/yy format (only filled in
automatically if they have looked at the cells)

What I need it to do is if cells in column G & H are blank then it keeps the
cells going in the same sequence down as it is already (but as Jan-07 format
for example)

If column G has input e.g. 31/04/07 then it changes column A to the
following month e.g. May-07.

And if column H has been filled in then it will change the date in A to a
year after the date it originally had e.g. May-07 will become May-08.

G will always take precedence over H if both are filled in.

Any help with this would be greatly appreciated as I am a complete novice at
the moment.