Home

Arrangement of Expiration dates.

%3CLINGO-SUB%20id%3D%22lingo-sub-1081768%22%20slang%3D%22en-US%22%3EArrangement%20of%20Expiration%20dates.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1081768%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20arrange%20Expiration%20dates%20beginning%20from%2001%2F01%2F2019%20to%2012%2F31%2F2019%20in%20a%20spreadsheet.%3C%2FP%3E%3CP%3EPlease%20provide%20me%20the%20solution%20or%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1081768%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1081781%22%20slang%3D%22en-US%22%3ERe%3A%20Arrangement%20of%20Expiration%20dates.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1081781%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F499946%22%20target%3D%22_blank%22%3E%40Himanshu_Parikh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWithout%20knowing%20any%20more%20than%20you%20have%20provided%2C%20all%20we%20can%20do%20is%20give%20you%20a%20general%20answer%3A%20%3CSTRONG%3EIF%3C%2FSTRONG%3E%20your%20dates%20are%20in%20fact%20Excel%20dates%20(i.e.%2C%20with%20an%20underlying%20serial%20number%2C%20and%20formatted%20as%20dates)%20then%20you%20can%20use%20DATA....SORT%20to%20sort%20the%20array.%20This%20will%20work%20with%20a%20table%20of%20data%20where%20there's%20other%20information%20about%20products%20or%20whatever%20to%20which%20those%20expiration%20dates%20apply.%20But%20%3CSTRONG%3EIF%3C%2FSTRONG%3E%20those%20dates%20are%20text%20masquerading%20as%20date%20fields%2C%20then%20the%20sort%20will%20not%20be%20in%20actual%20date%20order.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20use%20Data....Sort%20and%20see%20if%20it%20works.%20If%20it%20doesn't%20come%20back%20and%20let%20us%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20general%2C%20if%20you're%20going%20to%20ask%20a%20question%20like%20this%20it's%20a%20lot%20more%20helpful%20to%20you%20as%20well%20as%20to%20those%20of%20us%20that%20might%20be%20able%20to%20offer%20help%20if%20you%20upload%20a%20sample%20(devoid%20of%20private%20or%20proprietary%20info)%20of%20your%20actual%20spreadsheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1081782%22%20slang%3D%22en-US%22%3ERe%3A%20Arrangement%20of%20Expiration%20dates.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1081782%22%20slang%3D%22en-US%22%3EHighlight%20the%20table%20and%20use%20the%20sort%20function.%20You%20can%20find%20it%20on%20the%20data%20tab.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I need to arrange Expiration dates beginning from 01/01/2019 to 12/31/2019 in a spreadsheet.

Please provide me the solution or formula.

 

Thanks.

2 Replies
Highlighted

@Himanshu_Parikh 

 

Without knowing any more than you have provided, all we can do is give you a general answer: IF your dates are in fact Excel dates (i.e., with an underlying serial number, and formatted as dates) then you can use DATA....SORT to sort the array. This will work with a table of data where there's other information about products or whatever to which those expiration dates apply. But IF those dates are text masquerading as date fields, then the sort will not be in actual date order.

 

So use Data....Sort and see if it works. If it doesn't come back and let us know.

 

In general, if you're going to ask a question like this it's a lot more helpful to you as well as to those of us that might be able to offer help if you upload a sample (devoid of private or proprietary info) of your actual spreadsheet.

Highlighted
Highlight the table and use the sort function. You can find it on the data tab.