If cell (on another sheet) doesn't have a date, run different formula

[Jayker]

Hi All,

I have done numerous searches to try to find the answer for this, but cannot yet find one.


Here is my current formula:

=IF(ROWS(G$8:G8)>$C$4,"",INDEX('[Other File.xlsx]Master File'!$P$3:$P$10000,SMALL(IF('[Other File.xlsx]Master File'!$K$3:$K$10000>=$C$2,IF('[Other File.xlsx]Master File'!$K$3:$K$10000<=$D$2,ROW('[Other File.xlsx]Master File'!$K$3:$K$10000)-ROW('[Other File.xlsx]Master File'!$D$3)+1)),ROWS(G$8:G8))))

So right now, it is only populating the correct amount of rows that are found in the other sheet, which is great, and automatically pulling the correct data for each row. The problem is, my next column (on my Master File) is the next deposit someone would provide us, so not all of the rows have a deposit date listed as to when we received it. They are returning the value of 01-Jan-00. For those cells showing 01-Jan-00 I want to run a new formula to show when we would need to receive the deposit by in order for their project to stay on track.

Any help would be greatly appreciated!


Jason

 

[judgepax]

01-Jan-00 is just date-formatted 0.

=if([Current Formula]=0,[Formula for when need deposit],[Current Formula])

Yes cumbersome, but should do the trick.

 

[Jayker]

01-Jan-00 is just date-formatted 0.

=if([Current Formula]=0,[Formula for when need deposit],[Current Formula])

Yes cumbersome, but should do the trick.

Thanks judepax. Is my entire formula to go in the brackets of [current formula]?