T
Taryn
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!
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!