Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-06-2016, 08:59 AM
markg2 markg2 is offline A basic date math/data view question Windows 7 64bit A basic date math/data view question Office 2016
Expert
A basic date math/data view question
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default


There are two methods of adding/subtracting dates.

1. 5/6/16-5/1/16=5
2. 5/6/16-5/1/16=6

The second example you include the last date in value, the first you do not. The spreadsheet returns '5', the internet calculator when told to include the last day returns '6'.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Just Starting Out, Pretty Basic Question fishhead202 Word VBA 3 10-31-2014 05:56 PM
A simple math question markg2 Excel 6 03-01-2014 11:10 AM
Forms: A very basic question/request Coli Outlook 0 08-24-2011 11:14 AM
A basic question I'm sure. talosian PowerPoint 0 04-21-2011 05:43 AM
Auto-updating basic math functions & cross-referencing tables FranklinBluth Word Tables 13 11-19-2009 10:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:50 AM.


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