=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
|