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
