Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count month when date is in day/month/year format | Excel Worksheet Functions | |||
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
problem with entering month of the year | Excel Worksheet Functions | |||
trying to get day/month/year froamt while user enters year only | New Users to Excel | |||
Formula to return last day of month for each month in year? | Excel Programming |