| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate a date X number of days before/after given date
Hello!
I need to calculate set amount of days before a given date, and then set amount of days after a given date so users can input account information in correct time frame. Eg, always 21 days before project date or always 10 days after project end date = Project Lead up time & follow up time I believe I need to use something akin to the WORKDAY calculation but company always has a 7 day week and I do not know how to "include any and all days" in the calculation - 24/7 365 I am a very "newbie" Excel user! Is there something I can use "easily"? Any assistance is truly appreciated I did look through the postings, and also in google but it all went a bit over my head. :0) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY | Excel Worksheet Functions | |||
| Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| calculate the number of days from date received | Excel Worksheet Functions | |||
Threaded Mode
