Extract day from date in Excel
This isn’t rocket science, but I found it useful (once I got it right), especially when you have 20,000 records to extract the day from, as I often do. This works for dates formatted as such:
1/1/2001 (without leading zeros on the month or day)
and will give you the day, in the above case: 1
=IF(MID(A10,2,1)="/",(IF(MID(A10,4,1)="/",MID (A10,3,1),MID(A10,3,2))),(IF(MID(A10,5,1)="/", MID(A10,4,1),MID(A10,4,2))))- Download this code: extract-day-from-date-in-excel-1.txt
