b60

Hello, I need help with a function to populate the right date depending on what date another cell is: I need to have either 10/1/"current year" or 10/1/"next year" populated in cell D60 based on what date cell B60 is populated. If B60 is before 10/1/"current year", then I need to have...

<tbody> 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> I'm trying to build a table that pulls from another automatically and checks to see if my equipment items have failed...

If the date in cell T60 equals the date in $A$2, and the value in cell B60 is negative, display a blank. If the date in cell T60 equals the date in $A$2, and the value in cell B60 is positive, display the value in B60. If the date in cell T60 equals the date in $B$2, and the value in cell B60 is...