| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Current Month
How are the months written in the report (numerically or in words)
(ie. is April a "4" or "April")? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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")? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Current Month
Numerically
"Chip" wrote: How are the months written in the report (numerically or in words) (ie. is April a "4" or "April")? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum the current month | Excel Worksheet Functions | |||
| Subtract a future month from the current month to get remaining m. | Excel Worksheet Functions | |||
| Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
| Calculate the first day of the month for the current month? | Excel Discussion (Misc queries) | |||
| Current Month | Excel Worksheet Functions | |||
Linear Mode
