Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Months
How do I make it so that if someone inputs a month for an action that it
automatically makes the next column (month of review) have the value of the month after e.g. for an action in March it will need to be review in April |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Months
On Mon, 13 Nov 2006 04:06:01 -0800, Pasty
wrote: How do I make it so that if someone inputs a month for an action that it automatically makes the next column (month of review) have the value of the month after e.g. for an action in March it will need to be review in April How is the month inputted? Name? Number? Date? --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Months
"Pasty" wrote in message
... How do I make it so that if someone inputs a month for an action that it automatically makes the next column (month of review) have the value of the month after e.g. for an action in March it will need to be review in April Enter a list of months (January - December) somewhere (e.g. A1:A12). If month for action column is C, then with "May" in C1, the following formula will return "June". =IF(C1="December","January",INDEX($A$1:$A$12,MATCH (C1,$A$1:$A$12,0)+1)) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Months
Does your review sheet good for one year spreadsheet only, meaning 12 months
only...or 24 months Jan-06 to Dec-07..?? "Pasty" wrote: How do I make it so that if someone inputs a month for an action that it automatically makes the next column (month of review) have the value of the month after e.g. for an action in March it will need to be review in April |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Months
If you enter the month as text, e.g. December in cell A1 then this formula
will return next month =TEXT(("1 "&A1)+31,"mmmm") "Pasty" wrote: How do I make it so that if someone inputs a month for an action that it automatically makes the next column (month of review) have the value of the month after e.g. for an action in March it will need to be review in April |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Months
?
"Pasty" wrote: How do I make it so that if someone inputs a month for an action that it automatically makes the next column (month of review) have the value of the month after e.g. for an action in March it will need to be review in April |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My discovery on adding months and days to a date! | Excel Worksheet Functions | |||
Convert 2 digit month to 4 digit years and months | Excel Worksheet Functions | |||
CAn any one solve this problem of days months and years.its urgent plzzzzzzzzzzzz | Excel Discussion (Misc queries) | |||
months between 2 dates!!! | Excel Discussion (Misc queries) | |||
Why "datedif" function results sometimes negative numbers? | Excel Worksheet Functions |