counting days

J

Julian Campbell

I would like to enter a date into a cell and in the adjacent cell,
automaticaly count the days since the input date so the cell keeps a running
total of days.

Thanks
 
J

Julian Campbell

thanks. will try that

Julian
Ken Wright said:
Date goes in A1, In any other cell put

=TODAY()-A1

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission :)
-------------------------------------------------------------------------- --
Click to expand...
 
K

Ken Wright

Just remember to format as number as Excel might try being 'helpful' and make it
date format for you :)
 

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

Similar Threads

Need Help with a VBA subroutine 0
Using <= in countifs statement 1
Section and Page numbering 0
Adding cells until they are greater than a lookup cell and returning a value 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
formulas to count dates 2
number of week days in a period of time 5
Conditional Formatting - Given dates within certain range of days 4

Top