| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate Date
you're welcome and thanks for the feedback
"Jerome" wrote in message ... Thank you Julie that worked. "JulieD" wrote: Hi Jerome nest it if an IF statement e.g. =IF(B6<"",WORKDAY(B6,-35),"") or whatever test you want to use Cheers JulieD "Jerome" wrote in message ... Pardon me - irrelavant should be relavant. Cells without relavant data. "Jerome" wrote: Thanks JulieD, When filling down the formula I receive "#VALUE!" or "#NUM!" on cells without irrelavant data. How do I account for this? I tried writing the formula as =WORKDAY (B6,-35, " ") with no success. "JulieD" wrote: Hi if you have the analysis toolpak installed (tools / addins / analysis toolpak) you can use the WORKDAY function e.g. =WORKDAY(A2,-35) Cheers JulieD "Jerome" wrote in message ... I am trying to create a formula that will take a specific date in a cell and give the date 35 days prior. I am only concerned with Mon-Fri. So, if the date falls on a Saturday then give the Friday date. If the date falls on a Sunday, then give the Monday date. I am not sure where to begin. I wrote the following function of "= A2 - 32" Any help is greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate a date, 10 weeks after a set date & return a specific da | Excel Worksheet Functions | |||
| Trying to calculate end date using order date and lead time variab | Excel Worksheet Functions | |||
| Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
| formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
Hybrid Mode
