|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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. |
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 |
IF Formula to calculate dates | Sophie1 | Excel | 2 | 04-23-2014 07:19 AM |
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 |
Calculate date in word field | edwedw | Mail Merge | 3 | 11-30-2011 02:10 PM |