Working with advanced date calculations?

I'd like a cell in Excel to calculate "difference of two date cells" when the two cells have data entered. Plus, the cell should also be calculating from start date up to today's date(reflecting number of days so far) and should stop when stop date has been entered. Doing this, I should be able to know how many days have been consumed so far. It should also stop counting when the stop date has been entered. I am building an excel spreadsheet for recording working days. The employee can add a START and END date for each transaction. I would like the days cell to start calculating when the START date is entered reflecting how many days consumed up to date, and stop calculating when the END date has been entered. Is it possible? Any answers are highly appreciated for I am in a big mess tracking numerous transactions|||Excel represents dates as integer days from a beginning epic of 1 Jan 1900





So the first part of your question is easy - just subtract one date cell from another and format the difference cell as an integer to give the number of days elapsed.





For the more complicated stuff you want to do, review the date %26amp; time functions available.


"TODAY" returns the current date formatted as a date and "DATEVALUE" returns the integer representation of a date in text form. You can combine these with conditional (IF) functions to do your fancy tricks.