ExcelBanter - Current Month

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Current Month (https://www.excelbanter.com/excel-programming/334567-current-month.html)

Dave M.

Current Month

I am attempting to write code for a report that will total outstanding sales
orders dollars for the current month. How can I select the records that only
belong to the current month? Any help would be greatly appreciated.

Jim Thomlinson[_4_]

Current Month

How about doing a pivot table and grouping the date field by month.
--
HTH...

Jim Thomlinson

"Dave M." wrote:

I am attempting to write code for a report that will total outstanding sales
orders dollars for the current month. How can I select the records that only
belong to the current month? Any help would be greatly appreciated.

Chip[_3_]

Current Month

How are the months written in the report (numerically or in words)
(ie. is April a "4" or "April")?

Bob Phillips[_6_]

Current Month

=TEXT(date_cell,"mmmm d")

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Chip" wrote in message
oups.com...
How are the months written in the report (numerically or in words)
(ie. is April a "4" or "April")?

Dave M.

Current Month

I was attempting to write a macro that I could schedule to run each night
automatically.

"Jim Thomlinson" wrote:

How about doing a pivot table and grouping the date field by month.
--
HTH...

Jim Thomlinson

"Dave M." wrote:

I am attempting to write code for a report that will total outstanding sales
orders dollars for the current month. How can I select the records that only
belong to the current month? Any help would be greatly appreciated.

Dave M.

Current Month

Numerically

"Chip" wrote:

How are the months written in the report (numerically or in words)
(ie. is April a "4" or "April")?

All times are GMT +1. The time now is 11:24 AM.