Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 08-14-2014, 04:17 PM
macropod's Avatar
macropod macropod is offline Is this possible? - Calculate and Display the date range between 2 specific dates Windows 7 32bit Is this possible? - Calculate and Display the date range between 2 specific dates Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,384
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

Counting the number of intervening days is as simple as subtracting the earlier date from the later one. There isn't an in-built formula that will generate a list of those dates in a single cell, though. A UDF or macro would be required for that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
dates excel fields



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting - color only dates contained in a range EC37 Excel 1 07-08-2014 12:51 PM
Is this possible? - Calculate and Display the date range between 2 specific dates IF Formula to calculate dates Sophie1 Excel 2 04-23-2014 07:19 AM
Is this possible? - Calculate and Display the date range between 2 specific dates how to calculate backwards from a set finish date ketanco Project 1 02-07-2013 06:50 AM
Milestones: Display of - turning off the display of the date Pmacdaddy Project 3 01-18-2013 05:42 PM
Is this possible? - Calculate and Display the date range between 2 specific dates Calculate date in word field edwedw Mail Merge 3 11-30-2011 02:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:18 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