When and what is the minimum balance in my check register?!

I looked and didn't see a thread that answers this, if I missed it; my apologies. I, like dorlow, in another thread, have a check register in excel. The check register is already filled out for the rest of the year. (Yes, it's January, but I already know my house payments, car payments, average on monthly bills etc...)

I am looking for the date and amount that has the lowest balance in my check register.

Check register is sorted on DATE which is column A. BALANCE is column G. This is a pretty dynamic spreadsheet, so I am not looking for a solution where I have to key in a start or end date, I have been trying things like: '=MIN(IF(($A:$A>TODAY()-1),$G:$G,"")) to find the date with the lowest balance from today to the end of the year but can't get that to work.

If successful; when I open spreadsheet it will automatically recalculate and show:
Lowest Balance is $1234.67
Occurs on 8/19/20

(or what ever the correct values are)

Thank you so much for your time.
cc

Thank you so much for your help.
I have copied your formulas, but made a change or two.

1) I had the A:A to be dynamic and take care of any amount of entries in the register - to try to accomplish that within your example I changed the A1:A365 (don't forget some years have 366 days) to A2:A99999. The A2 skips A1 which holds the column title.

2) Again to be dynamic, (like not having to remember what and where needs to be changed for next year, and the year after) I hoped to replace the DATEVALUE("31/12/2020") with DATE(YEAR(TODAY()),12,31)

After making the changes both cells return #VALUE!

Knowing me, I probably made a small error somewhere. I guess the real problem is that I'm too picky in that it must be dynamic, and not need ay changes after the formula is entered, even when more records are added, or for subsequent years, or for years with 366 or 365 days.

Again, I do appreciate the help!! I've been struggling with this for a few weeks to no avail, and any and all help is appreciated. I'm sure it will eventually get solved.

Sounds Reasonable.. I opened workbook, clicked "File" upper left corner of screen. Goes to a screen whereby I can select blank templates. Left of screen has column with following options..."Home, New, Open, Info, Save, Save As, History, Print, Share, Export, Publish, Close, Account, Feedback, and Options". I do not see "Help" on that screen.

here is small version of checkbook, yes data has been sanitized and cut down but it does cover this year.

Saw account, clicked on it and I get a screen showing "Sign In" and "Microsoft Office Home and Student"... is that it?
I have included thanks in earlier post, and of course I will especially when we get this problem unraveled. Aligw, thanks for the time you put in here to bring the community forward. - to you I offer an old Greek Saying (Translated, of course) - I hope today is the best day you've had and the worst one you will ever have.
cc

Oops, typeo, it actually says - "Microsoft Office Home and Student 2016"