Google Sheets Date Formula

Django_Tester 0
Viewed 24

I have a personal finances Google Sheet with all my expenditures (column A) and corresponding dates (column B) of the month when they are due to be paid.

I would like to create a formula that shows me what is left for the remainder of the month depending on what day of the month I am looking at the sheet.

Something like, ifDate is today, sum all remaining dates of the month expenses.

TIA

google-sheets
1 Answers

Use this formula it works even if the dates is disordered.

=SUMIF(C2:C,">"&F2,B2:B)

enter image description here

Update

=SUMIF(D3:D,">"&TODAY(),C3:C)

enter image description here

Osm0
Related