| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a date (datevalue) to trigger adding a value to a cell
I have a list of the months over the next 3 years in column A (format is
01-Jan-08). Next to that list there is another list of values (starting at $50,000) next to each date. In January and July each year (except for Jan 08), I want $500 added to the $50,000, so by the end of the 2nd year, the value is $52,000. Do I use DATEVALUE in an IF or something else? Below is an example of what I mean. Please help! A B 1 1-Jan-08 50000 2 1-Feb-08 50000 .. .. 6 1-Jun-08 50000 7 1-Jul-08 50500 .. .. 12 1-Dec-08 50500 13 1-Jan-08 51000 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using date as trigger for macro | Excel Discussion (Misc queries) | |||
| Date-related problems - max and datevalue | Excel Discussion (Misc queries) | |||
| How can I get a date in exel to trigger a reminder in 30 days? | Excel Discussion (Misc queries) | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| DATEVALUE OF CURRENT DATE | Excel Worksheet Functions | |||
Threaded Mode
