View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BoniM BoniM is offline
external usenet poster
 
Posts: 353
Default manipulating dates

I am not at all sure what you mean, but to see a future date in Excel, all
you have to do is add the number of days. No special setup needed. if cell
A1 contains the date 03/24/2007:
03/24/07 =A1+7 =A1+30 =A1+365
would result in:
3/24/2007 3/31/2007 4/23/2007 3/23/2008


"ghostinhawaii" wrote:

How so I set up a spreadsheet or databse to recognize the text, weekly as 7
days monthly 30 and annual as 365 and then apply that to a current date to
see a future date? I have not been able to figure this out. thanks