Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Manipulating Data Problem | Excel Worksheet Functions | |||
Manipulating dates (was Add 6 months to a date) | New Users to Excel | |||
manipulating columns | Charts and Charting in Excel | |||
Manipulating Cell Contents? | Excel Discussion (Misc queries) | |||
Manipulating shapes | Excel Discussion (Misc queries) |