Formula Question concerning dates?

C

Chuck Dreier

I've wracked my brains for the formula that allows me to sum the days
between an entered date (A1) and the current date (E1). The "current date"
in the formula would be entered automatically into the E cell as part of the
formula. In other words, suppose A1 was 5/1/06 and today's date is 5/6/06.
E1 would know that 5/6/06 is today's date without my having to enter it, and
the formula would give me 5 days as the answer. Thanks!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top