If a Date falls within a Date Range, add up specific cells, etc

Without the use of VB, is it possible to do the following:

Based on either a Date Range or the Current Date, sum the these specific fields. So, based on today's date, add the cells A1, A3, A5, A7, A9. But, if today's date is the next day, then sum all those cells plus A11.

Example:

A1=1
A3=1
A5=1
A7=1
A8=1
A9=1
A11=1
A13=1

In the next column, in Row A, I want to sum A1 + A3 but only if today's current date falls within the date range 12/31/2018 to 01/13/2019. Once today's current date falls between 01/14/2019 and 01/28/2019, Add cells A1 + A3 + A5. Once current date falls between 01/29/19 and 02/10/19, Add cells A1 + A3 + A5 + A7.

Any assistance is appreciated!

Thank you,
Brian

Thanks Ben. Basically, I'm wanting to see the current balance of time entered and that time being entered is based up on each column having a date range it is associated with. The cell in that column may have a number in it. I'd like a single column/cell that will add up all the cells that are prior to today's current date ... from those columns that have dates associated with those numbers that are prior to and including today's date. I'll attach a spreadsheet as it is easier to understand. I have a tab/worksheet where I can keep dates, values, etc. that I can tie into formulas on the one I'm attaching. Thanks for any help.

That worked great Ben! Thanks very much.