Google Sheet : Query Formula Based On Date (Only format mm-yyyy)

hi all..

this formula working well with /for full date format.
i want to modified how to make formula work with format date as month & year

Please Login or Register  to view this content.

cause my date as complete/full format (mm-dd-yyyy).
my question how to display data with criteria date e.g. = 12-2001 (mm-yyyy)

for someone helping me, thank you so much..

john m

The date in cell D2 of the tab "Query Function" is formatted as "mm/yyyy". You will just enter the value as 12/2000 or 05/2001 or 7/1998 ..... so on

Check your sheet and see the formula in cell D6

The formula used is;

Please Login or Register  to view this content.

where the "date" in G2 is actually a text string styled as 10-1985

place this formula in cell G6:

Please Login or Register  to view this content.

OR:

Please Login or Register  to view this content.

You can use this formula as well to get the records, where the "Month" and "Year" values of the data is equal to the "Month" and "Year" of the date string in cell H2, where the date in cell H2 is actually a plain text and can be entered as 10-1985 or 10/1985

The formula in cell G6 is;

Please Login or Register  to view this content.

You can see this in your sheet.



Edit:

A more compact solution is to use the following formula to get the records, where the "Month" and "Year" values of the data is equal to the "Month" and "Year" of the date string in cell K2, where the date in cell K2 is actually a plain text and can be entered as 10-1985 or 10/1985

Please Login or Register  to view this content.

You can see this in your sheet as well.

The formula in cell J6 works for dates in the form of "mm/dd/yyyy" such as "4/12/1985" in cell K2 as well.

You can use "=" , ">=", "<" operators to fetch the desired results.