Excel Formula for Earliest Expiry Date

Terminé Publié le il y a 2 mois Paiement à la livraison
Terminé Paiement à la livraison

I am in need of a basic Excel formula that can help in filtering the first (earliest) expiry date from a list of many expiration dates. Here are the specific details:

- Format for the dates needs to be in DD-MM-YYYY.

- The original Excel file is continuously being updated with material numbers and multiple expiry dates. I need a tool or formula that can sort out and obtain the first (earliest) expiry date from these lists.

- Since the complexity of the requested formula or tool is Basic, an understanding of and experience with the Basic Excel functions is a requirement.

- Fluency in Excel and a knack for creating formulas that can simplify my work process are must-haves.

- Knowledge of or past experience in Material Management or Supply Chain would be a plus as it may lend some understanding to the task at hand.

The objective of this project is to streamline my work process, and your contributions to achieving that would be invaluable. Your expertise can help in managing our inventory more efficiently and enable us to serve our clients better.

Excel Visual Basic Traitement de Données Visual Basic pour les apps Saisie de Données

Nº du projet : #37819872

À propos du projet

30 propositions Projet à distance Actif il y a 2 mois

Décerné à:

(213 Commentaires)
7.4

30 freelances font une offre moyenne de 22 $ pour ce travail

P0L

Hello, I am an Excel expert and I would like to help you with your formula. Please check my profile and contact me to discuss further details. Regards.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(513 Commentaires)
8.1
daniyal3214

Hello, I am an experienced Excel expert holding years of experience. I will be happy to discuss in detail.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(243 Commentaires)
7.3
rahulg5466

--------------I CAN DO IT RIGHT AWAY--------------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VBA Scripting, building an excel file, excel dashboard, Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(67 Commentaires)
5.6
amokhtar70

Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how Plus

$30 USD en 4 jours
(35 Commentaires)
5.2
Jatin77777

Hello, I have more than 14 years of experience in reporting and data analysis. I have designed multiple dashboards and VBA automation to reduce human intervention to enhance data accuracy. These dashboards and reports Plus

$30 USD en 2 jours
(27 Commentaires)
4.8
ammar3215

I am expert in excel with 10+ years of experience , I can surely help you in basic Excel formula as i have done similars tasks like this for my clients and was able to complete them successfully , You can view my profi Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(10 Commentaires)
4.9
umairnoor32

Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver h Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(55 Commentaires)
4.3
tukabwanausi

For your requirement, I can use the MIN function combined with an IF statement in an array formula to filter out and find the earliest expiry date from your list of dates. Assuming your dates are in a column and format Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(12 Commentaires)
4.3
shahajalalbabu00

Hi Sameh! As a professional and dedicated freelancer, I understand the value of accurate and efficient data entry. My expertise in Data Entry, Data Processing, and Excel will surely prove useful for this project. I hav Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(29 Commentaires)
3.5
Sunitav36

Hi, I am interested in this project and i am ready to do it for you. To proceed further, I am ready to discuss your project and start immediately. Thanks

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(24 Commentaires)
3.9
AhmedRaza0107

As an experienced freelancer skilled in data entry, data processing, and most significantly Excel, I am confident in my ability to assist you with this project. For years, I have been utilizing Excel and its basic func Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
2.7
khunshaafzaal

Hi there, This is Khunsha Afzaal I am here to offer my services as a freelancer in the niche of data entry. I have gone through your project description and it perfectly complements my expertise. I am proficient in MS Plus

$20 USD en 4 jours
(5 Commentaires)
2.5
LeadScraper444

Hi there, I have read your requirement. I can make you the very best work completion with 100% accuracy in said time. I have expertise in Excel Automation using VBA, Excel Dashboards & Excel Advance formulas. Please Plus

$30 USD en 2 jours
(3 Commentaires)
2.2
khizarhayar50

With over a decade of experience as a Data Analyst and Virtual Assistant, I have developed an intricate understanding of Excel and its formulas, which makes me the perfect fit for your project. I am proficient in all f Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
0.1
CongJP

Hello I am a Vietnamese person with 8 years of experience in Excel, and Excel VBA especially data conversion/ analysis, and user interface. I am interested in your task and would like to apply. If possible please discu Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
0.0
stephendichu

With a strong background in data analysis and an advanced skill set in Excel, I firmly believe that I am well-equipped to handle your project. From my years of experience, I have come to thoroughly understand the expec Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
AnarEyvazov

Hello, To be honest, I am new to this platform as I am used to the office environment. I saw your ad and I want to work. Since I have been involved in product tracking before, this job suits me as well. I look forward Plus

$28 USD en 2 jours
(0 Commentaires)
0.0
Western23

Hi There With a prolific background in virtual assistance and profound fluency in Excel, I am keenly invested in your project. My 8 years of experience guarantees an adept understanding of the basic functions of Excel Plus

$15 USD en 3 jours
(0 Commentaires)
0.0
balaamlan4

As an experienced freelance data analyst, I understand the value of accuracy and efficiency in excel processing. I have spent considerable time honing my Excel skills, ensuring that I am able to create complex but user Plus

$10 USD en 7 jours
(0 Commentaires)
0.0
verma16gaurav

Hello Sir/Ma'am I am Gaurav verma it's my pleasure to work with you, sir i have a good experience in Excel Google sheet and data Entry Excel management, projects and i have a good skills excel i can finish this pro Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0