LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Pat Pat is offline
external usenet poster
 
Posts: 210
Default Count Days until Completion

Is there a way to count days (with a date enter in Start Column) until
"Completed" or "Cancel" is entered in my Status Column?

Right now, it is calculating on the Start and Completion Date. If the
completion date is blank - I receive wrong date in the duration column.

Start Date: 4/1/10
Completion Date: 4/5/10
Status: Completed
Duration: 4


--
pls
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count distinct days from two groups of days Colin Excel Worksheet Functions 4 February 17th 10 07:14 PM
Count Days more than 180 days prior to today Gregory Day Excel Worksheet Functions 4 March 28th 08 10:16 PM
When word says Install I want it count the days for 3 days w.o wee CYNTHIA Excel Worksheet Functions 1 March 23rd 08 05:28 AM
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made rhhince Excel Worksheet Functions 1 January 14th 07 09:56 PM
Count of days Albert Excel Worksheet Functions 5 March 2nd 05 08:33 PM


All times are GMT +1. The time now is 08:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"