98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Formula for dates
Formula for dates
Resolved · High Priority · Version 2007
Dawn has attended:
PowerPoint Intermediate Advanced course
Formula for dates
If i create a formula for dates with one column reading date from: and another column date to: and i want to see how many days are inbetween i.e. a simple formula = a minus b. does the date have to be written in a particular way in order for excel to understand how to work out how many days there are between the two dates?
RE: formula for dates
Hello Dawn,
Thank you for your question. The best way to calculate number of days between two dates is to type in the start and end dates as you proposed, into their own columns, in the format, for example: 12/01/2014. Then, in the third column, you enter the formula =B2-A2 (assuming the start date is in cell A2 and the end date is in cell B2) in cell C2. This will tell you the number of days between the two dates. Make sure cell C2 is formatted as "General".
I hope this is helpful.
Kind regards
Marius Barnard
Excel Trainer
Best STL
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding up rows or columns without seeing formulasHighlight a column or row and click the Autosum button. This gives you your answer without showing the formula. |