Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-13-2014, 01:49 AM
Premier-UK Premier-UK 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 2007
Novice
Is this possible? - Calculate and Display the date range between 2 specific dates
 
Join Date: Aug 2014
Posts: 2
Premier-UK is on a distinguished road
Question Is this possible? - Calculate and Display the date range between 2 specific dates

Thanks for assisting.

I have an issue where as:

I am trying to calculate the date range between 2 fields: eg

Start Date 01/01/2014 (A2) End Date 04/01/2014 (A3):


Formula results produce A2 .(something).A3 =
01/01/2014,
02/01/2014,
03/01/2014,
04/01/2014

Is there anything out there that can produce these dates.
Reply With Quote
  #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: 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

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
  #3  
Old 08-18-2014, 05:43 AM
Premier-UK Premier-UK 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 2007
Novice
Is this possible? - Calculate and Display the date range between 2 specific dates
 
Join Date: Aug 2014
Posts: 2
Premier-UK is on a distinguished road
Default

Thanks for looking into this. I thought it would require a macro, I'm hoping to explore all possible avenues before I go down the macro route.

Thanks for the option.
Reply With Quote
Reply

Tags
dates excel fields

Thread Tools
Display Modes


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 05:27 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