 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2006Months
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 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 > 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)) Does your review sheet good for one year spreadsheet only, meaning 12 months only...or 24 months Jan-06 to Dec-07..?? > 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 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") > 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 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.