Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2012, 06:40 AM
BBACCI BBACCI is offline help please Windows XP help please Office 2010 64bit
Novice
help please
 
Join Date: Apr 2012
Posts: 1
BBACCI is on a distinguished road
Default help please

I have a date in column A and again in column E is there a code that I can use to get the days between in column F?


And if so, how do I go about doing this.....this is my first time using excel (im old)
Reply With Quote
  #2  
Old 04-25-2012, 08:39 PM
MarvinP MarvinP is offline help please Windows 7 32bit help please Office 2010 32bit
Novice
 
Join Date: Jan 2012
Location: Seattle, WA
Posts: 12
MarvinP is on a distinguished road
Default

Hi BBACCI,

I'm old too...

You can simply subtract the earlier date from the later date and format it as a number or use the DateDif function.
Read http://www.theexceladdict.com/_t/t040303.htm
Reply With Quote
  #3  
Old 04-25-2012, 08:50 PM
excelledsoftware excelledsoftware is offline help please Windows 7 64bit help please Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Quote:
Originally Posted by BBACCI View Post
I have a date in column A and again in column E is there a code that I can use to get the days between in column F?
And if so, how do I go about doing this.....this is my first time using excel (im old)
just perform a sum. example in a1 you have 12-10-12 and in e1 you have 11-12-12 the sum a1 - b1 will show 28 days. Be sure to format the cell in column F as a general number or it will display as a date.
Reply With Quote
Reply



Other Forums: Access Forums

All times are GMT -7. The time now is 05:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft