Hi...I have a worksheet where dates are manually inputed. The columns are
labeled Input date (G2) and Date Closed (P2). The final column is labelled
Total Dates Open (W2) 1- What is the correct format I should use if I use the
Dateif function to calculate the total number of days from the Input date to
the Date closed. 2- Also, How do I use DateIF to caculate the input date and
today's actual date (real-time,until the date closed actually happens) to
still caculate the total dates open. For example G2 has an input date of
8/26/08 and P2 would have (todays actual date) and still caculate the Total
dates open to automatically display in column W2. Thanks!
--
TBJohnson