View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hoosiermomma Hoosiermomma is offline
external usenet poster
 
Posts: 4
Default How to add 30, 60 and 90 days to date and calculate deepening



"Dave" wrote:

Hi,
If your initial received date is entered into, say, C10, then:
in C11: =C10+30
in C12: =C10+60
in C13: =C10+90
Be sure to format C11:C13 as date.
Need more detail on the second requirement.
Regards - Dave

Thanks, Dave!
Do I have to do this on every row or can I enter the formula into the
columns of the table and have it fill in the rest of the row as the received
date is entered? As to the 2nd part: I want to list the initial price, then
the price -10% after 30 days, the price -20% after 60 days, and the price
-30% after 90 days.