![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#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] |
| 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 |