Find Column with Negative number and Post that date

[EWilson40]

Hey all!
New here and I'm stumped with a project I'm working on.
It basically is a financial sheet, like a financial forecast so we can see where we will be financially in the year.
It is probably relatively simple but I cant figure it out.

I am trying to have the date show where we will end up in the negative and have it fluctuate as we put in expenses, ect. Ive already gotten the formula for finding the negatives in a row but I cant get the column date to show beside the negative balance total.
The date is in range B1:AG1, the balances are in range B40:AG40.
Thanks all!

=TRANSPOSE(FILTER($B$1:$AG$1,B40:AG40<0))

Was what I was suggested but I don't need it to spill down and it isn't putting the date in. Just a bunch of random numbers.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=INDEX(FILTER($B$1:$AG$1,B40:AG40<0),1)

 

[EWilson40]

Hi & welcome to MrExcel.
How about

=INDEX(FILTER($B$1:$AG$1,B40:AG40<0),1)

That did stop it from spilling down. But it is still giving me a bunch of random numbers and not the actual date. 44774 is what is shows after I put in the formula.

 

[Fluff]

In that case you need to format the cell as a date.
44774 is the 1st Aug 2022

 

[EWilson40]

In that case you need to format the cell as a date.
44774 is the 1st Aug 2022

Genius....I don't even know why I didn't think of that.
Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.