Forum Discussion
Help Arranging Billing Dates
I know that this is a really simple issue, guys and gals. I am tracking monthly subscriptions. I have multiple columns with name, billing date, amount, and account. I have billing dates e...
cwatters86 I'm betting another person here will find a more clever solution but here is mine:
insert a new column with this formula (assuming col A has the 1st, 2nd, 3rd, etc... text in it):
=IF(ISNUMBER(--LEFT(A1,2)),--LEFT(A1,2),--LEFT(A1,1))Then sort by this new column