| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with Dates: Calculating A Running Total for Days Held
PROBLEM 1 I have 2 columns, One column with Dates entered, and one column that would like to calculate how many days it has been since the dat entered. _Date_Entered_(Or_Purchased)_ This is column "A" _Days_Since_Date_Entered_(or_Todays_date_less_Date _entered)_ This i column "BT" How do I created a formula for this column based on Date Entered? PROBLEM 2 Column "BU" is a drop down box that gives 2 possible choices. 1. Incomplete 2. Complete When the end user chooses complete, I want the system date to show i column "BV". Does anyone have any suggestions? (I'm an Excel novice) Thank you -- Mcastee ----------------------------------------------------------------------- Mcasteel's Profile: http://www.excelforum.com/member.php...fo&userid=1569 View this thread: http://www.excelforum.com/showthread.php?threadid=31455 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating running total. | Excel Discussion (Misc queries) | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| running total for last 7 calender days | Excel Discussion (Misc queries) | |||
| Calculating # of busn days, not just calendar days, between 2 dates? | Excel Programming | |||
| Calculating total days from 2 dates | Excel Programming | |||
![Mcasteel[_47_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
