| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare shorter date range against longer date range
Hi Excel Gurus !
I am in need of a macro / formula which is able to find the missing date range(s). Example: John stayed in Apartment A&B for period : 1 February until 15 September. Rental paid shown in records : Apartment A rental period : 1 January until 28 February Apartment B rental period : 1 April until 31 July Apartment A rental again : 1 June until 31 August (overlaps) The above start date - end date is keyed into cell A1:B3. I need excel to show results : 1 March - 31 March 1 September - 15 September which represent periods where no rental paid was shown in records. My thousand thanks! in advance for any help on this. SauQ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare an Array to a Date Range | Excel Discussion (Misc queries) | |||
| how to compare a date range another range | Excel Programming | |||
| Rolling up the latest date, criteria of range to compare highest d | Excel Programming | |||
| copy date based on date -refer to date range | Excel Programming | |||
| Compare date of a transaction against a range of dates | Excel Worksheet Functions | |||
Threaded Mode
