| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto return month as text date
I have a spreadsheet with the following columns January 06 February 06 March06 April06 May06 Etc Jan-06 Apr-06 Jan-06 Feb-06 May-06 I would like to create a spreadsheet that automatically returns the month based on a 3month cycle e.g. enter Jan-06 and Apr06 automatically returns in the April 06 column enter Feb06 and May06 auto fills in May column, and so on - (the spreadsheet is based on a 12 month cycle) Can anyone provide the formula for this Many Thanks -- martins ------------------------------------------------------------------------ martins's Profile: http://www.excelforum.com/member.php...o&userid=31616 View this thread: http://www.excelforum.com/showthread...hreadid=524041 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
| extract the month of a date | Excel Discussion (Misc queries) | |||
| GETTING MONTH FROM A DATE | Excel Discussion (Misc queries) | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Return the end of month date from a date | Excel Worksheet Functions | |||
Threaded Mode
