| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date !
Hi,
I have 3 columns which states like this Col A Col B Col C Start End status 01-jan-2008 - pending 21-jan-2008 - pending 1-Feb-2008 - pending End date are not specified as it is not completed. What i need is - if the status is pending then count the number of days (pending). Eg., in the above example all are pending, in my original file I have completed status(which will have end date). I thought of using this but unable to get the desired result =today()-Average(pending dates) Thanks a lot |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates - Need to display date one month prior to user-entered date | Excel Worksheet Functions | |||
| how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Threaded Mode
