| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
€œIf€ problem around dates
I want to enter some data into a cell dependant upon a date range.
If the date in cell €œA€ is between 1-Dec-06 and 28-Feb-07 return 02-07 into cell €œB€ If the date in cell €œA€ is between 1-Mar-07 and 31-May-07 return 05-07 into cell €œB€ If the date in cell €œA€ is between 1-June-07 and 31-Aug-07 return 08-07 into cell €œB€ If the date in cell €œA€ is between 1-Sep-07 and 30-Nov-07 return 11-07 into cell €œB€ If the date in cell €œA€ is between 1-Dec-07 and 28-Feb-08 return 02-08 into cell €œB€ Etc - Etc -- Cheers Andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with dates | Excel Worksheet Functions | |||
| Problem with dates | Excel Discussion (Misc queries) | |||
| Problem Dates | Excel Discussion (Misc queries) | |||
| Formatting cells Auto fill color using €œIf€ | Excel Worksheet Functions | |||
| Problem with dates | Excel Worksheet Functions | |||
Threaded Mode
