Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-15-2015, 01:56 PM
gblosser gblosser is offline Which Office program to use to find a day/date Windows 7 64bit Which Office program to use to find a day/date Office 2013
Novice
Which Office program to use to find a day/date
 
Join Date: Jan 2015
Posts: 3
gblosser is on a distinguished road
Default Which Office program to use to find a day/date

I need to be able to easily find a range of dates in the future from any given date. For example I need to schedule a test of some equipment not less than 20 days or not more than 40 days from the previous test. I have not been able to do this on my own via searches through my Office software, Can someone here direct me to the solution?
Reply With Quote
  #2  
Old 01-15-2015, 04:09 PM
themausman themausman is offline Which Office program to use to find a day/date Windows 7 32bit Which Office program to use to find a day/date Office 2013
Competent Performer
 
Join Date: Oct 2014
Location: the Netherlands
Posts: 144
themausman is on a distinguished road
Default

How about using Excel for this. Check out the DateDif function that can accomplish exactly what you are looking for. Syntax: =Datedif(datefield one, datefield two, "YY")
where the last option can also be "DD" as in days. This will give you the difference in days.
Reply With Quote
  #3  
Old 01-16-2015, 05:21 PM
macropod's Avatar
macropod macropod is offline Which Office program to use to find a day/date Windows 7 64bit Which Office program to use to find a day/date Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

In Excel, all you need do is type the date in one cell, the number of days offset in another, then sum the two just like you'd do with any other two values. It can also be done in Word, but nowhere as easily as in Excel.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 01-16-2015, 05:23 PM
macropod's Avatar
macropod macropod is offline Which Office program to use to find a day/date Windows 7 64bit Which Office program to use to find a day/date Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by themausman View Post
How about using Excel for this. Check out the DateDif function that can accomplish exactly what you are looking for. Syntax: =Datedif(datefield one, datefield two, "YY")
where the last option can also be "DD" as in days. This will give you the difference in days.
The Datedif function calculates the difference between two dates - it doesn't really aid in calculating dates.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 01-17-2015, 04:05 AM
themausman themausman is offline Which Office program to use to find a day/date Windows 7 32bit Which Office program to use to find a day/date Office 2013
Competent Performer
 
Join Date: Oct 2014
Location: the Netherlands
Posts: 144
themausman is on a distinguished road
Default

Agree Paul, but you can use the result in an IF statement and then use this to calculate the difference. You technique is shorter and more efficient. OP has a choice
Reply With Quote
  #6  
Old 01-17-2015, 05:44 AM
gblosser gblosser is offline Which Office program to use to find a day/date Windows 7 64bit Which Office program to use to find a day/date Office 2013
Novice
Which Office program to use to find a day/date
 
Join Date: Jan 2015
Posts: 3
gblosser is on a distinguished road
Default Thank You

I was making that way too hard, but searches for help on Office programs were not productive either. A bit of formatting to get the results to display as I wanted and practicing on functions got me where I wanted to go with your assistance!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Which Office program to use to find a day/date How do i add another office program? isaaclopez8835 Office 1 10-23-2014 12:33 PM
How to change the language in MS Office (in the individual program) licw Office 0 09-30-2011 02:51 AM
Which Office program to use to find a day/date Load just 1 program from Office 2010 EllieW Office 2 08-09-2011 10:11 AM
Office 2007: Adding a program Steve_D Office 0 10-27-2010 03:39 AM
I cannot open a hyperlink in an office 2003 program ArmandoS Office 3 11-26-2005 12:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:04 PM.


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