Hi There I have huge amount of data for the last 5 months
I have sorted data on submit date desc . Now I have to select data for the last 4 months from here.
IThe date format is mm/dd/yyy hh:mm:SS AM?PM
Now I tried creating a new coulmn called monthsort and used the formula Month(A2) expecting to see the month number there.
I donot see that instead I see a date of 01/01/1900
How would you do this.
Any help is appreciated.