My downloaded report consists of the following columns with 200+ rows:
A = invoice date
B = invoice number
C = Payee
D = date range (in text format) example: 07/29 – 08/12/18
E = amount
The first part of my reporting needs to pull a month and year from the information in column D. My example above should show July 2018 as the result.
For the second part I need use the amount in E to calculate the total by month, giving a monthly projection.
Thanks for looking,
Virginia
A = invoice date
B = invoice number
C = Payee
D = date range (in text format) example: 07/29 – 08/12/18
E = amount
The first part of my reporting needs to pull a month and year from the information in column D. My example above should show July 2018 as the result.
For the second part I need use the amount in E to calculate the total by month, giving a monthly projection.
Thanks for looking,
Virginia