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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with Dates: Calculating A Running Total for Days Held
To calculate the number of days: =A1-B1
To calculate the number of work days: =NETWORKDAYS(a1-b1) HTH, Gary Brown "Mcasteel" wrote: PROBLEM 1: I have 2 columns, One column with Dates entered, and one column that I would like to calculate how many days it has been since the date entered. _Date_Entered_(Or_Purchased)_ This is column "A" _Days_Since_Date_Entered_(or_Todays_date_less_Date _entered)_ This is 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 in column "BV". Does anyone have any suggestions? (I'm an Excel novice) Thank you. -- Mcasteel ------------------------------------------------------------------------ Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698 View this thread: http://www.excelforum.com/showthread...hreadid=314556 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with Dates: Calculating A Running Total for Days Held
Problem 2: Assuming this is ListBox1, put this code in the listbox code
module: Private Sub ListBox1_Click() If ListBox1.Value = "Complete" Then Range("BV1").Value = Now Else Range("BV1").Value = "" End If End Sub Format the cell for the date display of your choice. Mike F "Mcasteel" wrote in message ... PROBLEM 1: I have 2 columns, One column with Dates entered, and one column that I would like to calculate how many days it has been since the date entered. _Date_Entered_(Or_Purchased)_ This is column "A" _Days_Since_Date_Entered_(or_Todays_date_less_Date _entered)_ This is 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 in column "BV". Does anyone have any suggestions? (I'm an Excel novice) Thank you. -- Mcasteel ------------------------------------------------------------------------ Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698 View this thread: http://www.excelforum.com/showthread...hreadid=314556 |
Reply |
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 |