Solved

Calculating number of calender days in Excell

Posted on 1997-10-30
1
376 Views
Last Modified: 2009-08-26
If I have 2 columns in a spreadsheet, depicting a date in each, with the following format yyyy/mm/dd. How can I calculate the number of calender days and not just the difference between the two? e.g. 19970202 and 19970530.
I basically need to know the calender days difference.
0
Comment
Question by:chrisolsen
1 Comment
 
LVL 1

Accepted Solution

by:
lprice earned 200 total points
ID: 1604546
Create your coloums, making sure the cell is formatted to the above i.e yyyy/mm/dd
In you formula column put he following formula sum(b2-a2)(changing the cell references to fit in with your spreadsheet.)
The format the formula cell to number with no decimal places.
This will result in the answer in calendar days.
If this is not the result you are looking for let me know.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure: First, sum up all the individual digits in the number If that sum value has more than one digit, then sum up …
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now