| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to update a cell if a specific date is included in a date rang
I hope I can explain my problem:
These are my columns: "Start" "End" "Start", "End " "License" "01/1/06","02/1/06",....."12/1/10" 2/1/06 2/28/06 12/1/10 12/31/10 150 150 150 3/1/06 3/31/06 200 1/1/07 6/30/07 100 4/1/07 9/30/07 75 . . . . . . I need to look at the date on the columns and compare it to Start date & End Date. If the column date is between these ranges, copy the corresponding license amount under than date column; if not leave it blank.(like the sample above). I have been trying different ways with IF( ) but so far no luck. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I prompt a user to update a cell value (ie the date)? | Excel Worksheet Functions | |||
| Date last update for the file | Excel Discussion (Misc queries) | |||
| Update cell based on date range | Excel Discussion (Misc queries) | |||
| Change cell color dependin on date ... | Excel Worksheet Functions | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
Threaded Mode
