| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate Project dates
I need to calculate a project date 60 days from any given date, but the
formula will only let me do weekdays. I need to do 60 calendar days including holidays. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate Project dates
Hi,
if your date is in cell A1 and you want the result in B1 enter =A1+60 "Pat" wrote: I need to calculate a project date 60 days from any given date, but the formula will only let me do weekdays. I need to do 60 calendar days including holidays. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate Project dates
Opps, I misunderstood your question, use
=WORKDAY(A1,60) "Eduardo" wrote: Hi, if your date is in cell A1 and you want the result in B1 enter =A1+60 "Pat" wrote: I need to calculate a project date 60 days from any given date, but the formula will only let me do weekdays. I need to do 60 calendar days including holidays. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate number days + hours to complete a project | Excel Worksheet Functions | |||
| Multiple user time collection by project and dates? | Excel Discussion (Misc queries) | |||
| How do I calculate dates backwards from a project end date | Excel Worksheet Functions | |||
| Find project start and end dates in a DB with many different proje | Excel Worksheet Functions | |||
| How do I calculate the hours spent on a project by entering a sta. | Excel Worksheet Functions | |||
Linear Mode
