If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cash Statement- Accruing balances
we are attempting to create a Cash Statement report for a single account and
would like to include a To Date, Month To Date and Fiscal Year totals. Is there a formula out there that can accomplish this? We will be manually inputting the "To Date" amount in its dedicated field. Today This month to date Fiscal year to date $6,956.20 $- $- |
#2
|
|||
|
|||
Cash Statement- Accruing balances
You probably want Sumif, as in:
=sumif(a:a,"="&date(year(today()),month(today()), 1),b:b) The other formula would be similar, but a different starting date. Regards, Fred "cjarrar" wrote in message ... we are attempting to create a Cash Statement report for a single account and would like to include a To Date, Month To Date and Fiscal Year totals. Is there a formula out there that can accomplish this? We will be manually inputting the "To Date" amount in its dedicated field. Today This month to date Fiscal year to date $6,956.20 $- $- |
Thread Tools | |
Display Modes | |
|
|