| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to add a value based on a date change in Excel?
I am trying to add a value to another on the first of the month. It is a
repeating condition based on the first of the month. Thanks for your help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to add a value based on a date change in Excel?
Do you want to add the same amount on the first of every month?
If, for instance you want to add the amount in cell B1 every first of the month from October 2006 =DATEDIF(DATE(2006,10,1),TODAY(),"m")*B1+B1 "Eric" wrote: I am trying to add a value to another on the first of the month. It is a repeating condition based on the first of the month. Thanks for your help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to add a value based on a date change in Excel?
Yes, I am trying to add the same amount every month to a value. Can I ask it
to add another cell if the date is the first of the month? EX: I have 200 hours of vac, accuring 12 hours a month on the first of every month. If I place the cell with the total accured next to the amount accured each month so it updates the first. "daddylonglegs" wrote: Do you want to add the same amount on the first of every month? If, for instance you want to add the amount in cell B1 every first of the month from October 2006 =DATEDIF(DATE(2006,10,1),TODAY(),"m")*B1+B1 "Eric" wrote: I am trying to add a value to another on the first of the month. It is a repeating condition based on the first of the month. Thanks for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel date scheduling not msProject | Excel Worksheet Functions | |||
| Date format from excel to CVS file wont. Change in CVS wont stay. | Excel Worksheet Functions | |||
| How do I change a date format 3/14/2006 to 3-14-2006 in Excel 2002 | Excel Discussion (Misc queries) | |||
| Can I program Excel cells to change colour at a set date? | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
Linear Mode
