Time Interval Formula

The_Game

New Member
Joined
Mar 27, 2015
Messages
27
Item 260
A/C 2121
Date failed: 15 May
Fault: B60
Item 260
A/C 2121
7 May
B60
Item 260
A/C 2003
3 May
B60/CS
Item 260
A/C 2103
6 Jul
B60

<tbody>
</tbody>
I'm trying to build a table that pulls from another automatically and checks to see if my equipment items have failed within a 3 month interval. I've tried using the V/HLookup formula, but I don't know how to program excel to build me a new table based off items failing inspections within a 3 month time period of its last fail date. The first cell is the Item Name, A/C is aircraft #, then date failed, followed by what it failed. How can I use V or HLookup to search a table for an item with recurring fails in a 90 day period?

Thank you!
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,109,140
Messages
5,527,059
Members
409,742
Latest member
setam

This Week's Hot Topics

Top