To Change date format to month & year
Closed
Kishore
-
Oct 31, 2011 at 11:48 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 1, 2011 at 07:28 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 1, 2011 at 07:28 AM
Related:
- To Change date format to month & year
- Excel date format dd.mm.yyyy - Guide
- How to change whatsapp time format - Guide
- How to change idm language - Guide
- Format factory - Download - Other
- Change computer name cmd - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 1, 2011 at 07:28 AM
Nov 1, 2011 at 07:28 AM
I do not know what is your regional configuration for entering dates. In my area dates are entered as mm/dd/yy so that it will be recognized as date and can be manipulated . But it is also possible to write as you have entered in which case the date entries are strings. In some regions it is configured to enter dates in excel as dd/mm/yy.
however in my excel your B column will be strings.
suppose in A15 you enter Kishore (better copy from column A of data so that no spelling mistake occurs)
in B15 enter this formula
=SUMPRODUCT(($A$1:$A$7=A15)*(MID($B$1:$B$7,4,2)="10")*($C$1:$C$7))
hit enter.
you will get 800
if there are other names below A15 you can copy B15 provided you need result for October.
however in my excel your B column will be strings.
suppose in A15 you enter Kishore (better copy from column A of data so that no spelling mistake occurs)
in B15 enter this formula
=SUMPRODUCT(($A$1:$A$7=A15)*(MID($B$1:$B$7,4,2)="10")*($C$1:$C$7))
hit enter.
you will get 800
if there are other names below A15 you can copy B15 provided you need result for October.
