dear all,
every time i download my excel report it has date format of "mm/dd/yyyy" and till date, I have been using countif function to count the month from it and before that I have to convert the date using the function =text(value, format) then only able to count it.
is there any alternative where I can count the months without converting the date.
i have uploaded the sample excel file to make my question clear.
regards,
Bookmarks