Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Date
Hi all, Is it possible to have a cell say "b1" read from a cell "A1" and automatically change to the following month. So If say "A1" was January, I want "b1" to be february but I need it to be calcuated by a function. To date I have just been adding 31 days to each cell in column a which has worked. i.e "b1" formula reads = a1+31 etc... I am using David McRichies "Insertandfillformulas" but for some reason it can't read column A this formula and things aren't working !. Thanks for your help Regards, Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Date
David may have more to say but you can play with this
=DATE(YEAR(A1),1+MONTH(A1),DAY(A1)) If it also fails to work with anything in column A you should highlight the problem cell and examine with menu item Format/cells - it's probably not interpreted as a Date by Excel. Is it possible to have a cell say "b1" read from a cell "A1" and automatically change to the following month. So If say "A1" was January, I want "b1" to be february but I need it to be calcuated by a function. To date I have just been adding 31 days to each cell in column a which has worked. i.e "b1" formula reads = a1+31 etc... I am using David McRichies "Insertandfillformulas" but for some reason it can't read column A this formula and things aren't working !. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Date
Thanks guys. -----Original Message----- Michael, Try this - In A1 enter 1/1/00 in cell B1 enter =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) drag the formula across as far as you want, e.g. to December. Then format all of these cells using - Format, Cells, Number Tab, Custom, Select "mmmm" Hope that's what you're after regards, John "Michael" wrote in message ... Hi all, Is it possible to have a cell say "b1" read from a cell "A1" and automatically change to the following month. So If say "A1" was January, I want "b1" to be february but I need it to be calcuated by a function. To date I have just been adding 31 days to each cell in column a which has worked. i.e "b1" formula reads = a1+31 etc... I am using David McRichies "Insertandfillformulas" but for some reason it can't read column A this formula and things aren't working !. Thanks for your help Regards, Michael . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic date value | Excel Worksheet Functions | |||
automatic date | Excel Discussion (Misc queries) | |||
Automatic date | Excel Worksheet Functions | |||
Automatic date | Excel Discussion (Misc queries) | |||
automatic date | Excel Worksheet Functions |