| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
=100-(1.5*INT((TODAY()-DATEVALUE("1/1/2005"))/30))
assuming that the starting value you want reduced by 1.5 is 100 and the starting date is 1/1/05 "Mikel" wrote in message ... I would like to have one cell that will decrease in value by 1.5 every 1st day of the month |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) | |||
| SUMPRODUCT with date range question | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. | Excel Worksheet Functions | |||
| How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions | |||
Hybrid Mode
