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
|