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