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.
|