| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date Format Inside of a SUMIF Statement
Greetings,
I am trying to get the sum for each month in a column which has thee entire year. So far I have: SUMIF($B:$B,{need month and year here},$DT:$DT) B is formatted as mm/dd/yy I need mm/yy in the formula. I can't remember how to do this! Anyone have any ideas? Any help would be appreciated. TIA -Minitman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
| How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
| How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
| Opening a csv file with US date format on a Australian PC | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
Threaded Mode
