| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
selection based on a date in a cell
Hi,
I want to put specific data into a cell, based on the date in another cell. i.e. if the date is between two specific dates, populate the other cell with "A", if between two other dates then "B" etc. I want to fill in a table of the dates (which are financial periods 1 to 12), so if the date is in period 1, "P 01" is populated to a specific cell. Is this possible? hope someone can help, kind regards, Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change data in a cell, based on the date | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Threaded Mode
