-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
b60
-
Excel Function to Produce Correct Date
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...- cmschmitz24
- Thread
- b60 d60 date populated year
- Replies: 10
- Forum: Excel Questions
-
T
Time Interval Formula
<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...- The_Game
- Thread
- a/c b60 date failed item
- Replies: 0
- Forum: Excel Questions
-
S
How can I get these sentences to become one formula? if/and/or
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...- ShineMagical
- Thread
- b60 cell date display t60
- Replies: 1
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
