Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATE ISSUE!
i AM ATTEMPTING TO FORCAST THE AMOUNT OF DAYS IN A SHEET, HERE'S THE EXAMPLE:
Start date Days since 100 day forcast 5-31-06 TODAY HOW DO I GET THIS??? I can the days till today but not get a date from start date plus 100 days? I appreciate your input. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATE ISSUE!
This will give you a date that is 100 days past the date in cell A2
=A2+100 Vaya con Dios, Chuck, CABGx3 "Joan" wrote: i AM ATTEMPTING TO FORCAST THE AMOUNT OF DAYS IN A SHEET, HERE'S THE EXAMPLE: Start date Days since 100 day forcast 5-31-06 TODAY HOW DO I GET THIS??? I can the days till today but not get a date from start date plus 100 days? I appreciate your input. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATE ISSUE!
"Joan" wrote in message
... i AM ATTEMPTING TO FORCAST THE AMOUNT OF DAYS IN A SHEET, HERE'S THE EXAMPLE: Start date Days since 100 day forcast 5-31-06 TODAY HOW DO I GET THIS??? I can the days till today but not get a date from start date plus 100 days? I appreciate your input. If your start date is an Excel date, rather than text, then merely add 100 to that format the result as a date. If your 5-31-06 is text, try Data/ Text to columns & choose date, with the DMY option. That will turn it into a date to which you can add your 100 days. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average value from a table | Excel Discussion (Misc queries) | |||
Calculate 1st of month date from existing date. | Excel Discussion (Misc queries) | |||
Date format issue | Excel Worksheet Functions | |||
Another Date issue. | Excel Worksheet Functions | |||
Date conversion issue "^" symbol | Excel Discussion (Misc queries) |