Is this possible? - Calculate and Display the date range between 2 specific dates

Premier-UK · #1 08-13-2014, 01:49 AM

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.

macropod · #2 08-14-2014, 04:17 PM

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.

Premier-UK · #3 08-18-2014, 05:43 AM

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.

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