Adding Dates [Solved/Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,
I am trying to find a formula that calculates dates. Like I have two boxes with a beginning and date in them, and I want to calculate the days between. Example - Work dates 10/1/09 - 10/3/09 and I want a formula that calculates that it equals a total of 3 days. Can I do that?

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hello

If you have the dates in A1 & B1 and then in C1 put =B1-A1+1
Excel considers the date as a number
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4229 users have said thank you to us this month