I received this question the other day and it's I had this question on I have a
video that you highlight the invoices that are over a 60 days they haven't
been paid in 60 days so you know which ones to deal with in this one this
gentleman says is hi barb how can I also submit from the above example I have to
all add all the balances older within 30 days example in your example it says you
have original balances and disbursements on column B how can you add such
balances after one month so what I did I'll show you my finished product here
is I did I did balances over 30 days and balances over 60 days and then I total
them and so I'll just show you how I did it so basically how I start this whole
premise is up in here as I put today which is equals today opening bracket
closing bracket and it will give you today's date but tomorrow when you will
open it up it'll say tomorrow's date so then whether these invoices are over 30
days you'll be accurate to the day that you're doing it on so what I'm going to
do is first of all I'll calculate 30 so we'll go equals and I'm gonna do an if
statement and I'm gonna go if this date plus 30 if it's less than this date and
what you're gonna do is you are going to display this value here and if not net
another comma we're gonna display nothing it's gonna be blank and so then I'm gonna
close that and you're gonna get 250 and what we're gonna do when we look at this
so we can drag it down is we're gonna click on the I I 1 here and we're gonna
press an f4 so we can absolutely reference it
now press ENTER and then what we're gonna do is we're gonna double click on
the fill handle to fill it all the way down and why don't I put those into
currency here okay so let's do this again
let's go equals and let's do it for 60 days so we'll go equals and we'll go if
we select this value and we go plus and we go 60 and if it's less than if it's
less than today's date and let's F for that last one so that it's absolutely
referenced then we are going to display the value for else we're going to
display a blank so we'll just put double quotation marks here and we're going to
close the bracket and we're going to press ENTER and then once again we're
gonna double click down this value and change it to currency now to get the
totals what we're going to do is we're gonna go to the bottom here and we're
gonna hit the automatic sum button now it doesn't know what to add so I'm going
to suggest that these ones are the one we want to add and press Enter
and what we can do is we can just click on this and drag your cross to get there
the total for the 60 days as well so let's double click to get it so we can
read it and so now what we're gonna do is up here in e equals our total over 30
days is we'll go and get the total from the total row here
and then of course we can drag that across so it gets the total from the 60
row over 60 days real nerve column so let's double click that to make it tum
to make it there and so that's how you calculate the total value owed to you
that's over 30 days and over 60 days please subscribe