Excel Formula required to colour squares based on dates


I am after a formula that can be used to take dates Column C and Column E from the DATA tab and colour in the corresponding squares in the Results tab. I am trying to track the removal month.

For example the first entry is for 10001 and the 1st removal date is 20/3/2021 (column C) and the second removal date is 19/5/2021. If you look at the Results sheet you will see March 2021 has been coloured in and so has May 2021 against 10001 record. The cell also contains the removal miles number.

Kemahiran: Excel, Pemprosesan Data, Pemasukan Data, Visual Basic

Lihat lagi: background colour change based parts day, run excel vba select update filed based criteria, freelancer required find indian based manufacturer, transform cvs data formula cells excel, excel expert required saudi arabia, excel dll required net application export excel, remote excel programmer required, excel stand programme hmtl web based, freelance excel specialist required, freelance excel work required, excel expert required, clean excel file required format, excel reverse engineer data formula, excel based labour time sheet, excel work required, excel professional required, required implement pdht based logic pastry reference, simple excel formula required, excel input required, excel skills required data entry

Tentang Majikan:
( 19 ulasan ) Derby, United Kingdom

ID Projek: #29441083

Dianugerahkan kepada:


Dear Sir, I have reviewed your requirements and the file attached. I have vast experience with Excel and I will be very glad to help you accomplish this task. Best regards, David Barrios

$15 USD dalam sehari
(9 Ulasan)

19 pekerja bebas membida secara purata $24 untuk pekerjaan ini


Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in sam Lagi

$35 USD dalam sehari
(436 Ulasan)

Hi,"I am an Excel Expert with Professional experience working with Excel. I have more than 10 year experince with excel. Complete a lot of jobs on Freelancer with highly satisfaction of client. I believe I can do a gre Lagi

$29 USD dalam sehari
(489 Ulasan)
(361 Ulasan)

Hello Greetings to you!! I am an Excel (Macro)/Visual Basic expert and interested to work with your project. I have checked your requirements and that makes complete sense to me. I assure you of a high-quality job. Ple Lagi

$30 USD dalam sehari
(349 Ulasan)
(206 Ulasan)

Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 day

$30 USD dalam sehari
(108 Ulasan)

Hello I am available to modify according to your need. can we discuss? John

$22 USD dalam sehari
(57 Ulasan)
(32 Ulasan)

Hi I am an expert in Excel and VBA application. I can help you with this task fast and accurate. Contact me to discuss. Regards!

$20 USD dalam sehari
(27 Ulasan)

Hi, I have gone through your requirement and can complete the project in 3 hours. I have 6 plus years of experience in Excel VBA/Macro . Please get in touch to get started ASAP.

$20 USD dalam sehari
(1 Ulasan)

Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well.

$15 USD dalam 5 hari
(0 Ulasan)

Hello, I believe I can provide you the solution. My program will be as below if you choose to work with me: Day-0) A detailed meeting to discuss job in details for a better understanding of the job Day-1) I will code Lagi

$23 USD dalam 2 hari
(0 Ulasan)

I am Certified Microsoft Office Specialist working in the field for 3 years. Looking forward to pursue this proposal

$25 USD dalam 2 hari
(0 Ulasan)

I am interested in work with you and it is also good for you because I can do work on ms Excel so i do work with more accuracy

$20 USD dalam 7 hari
(0 Ulasan)

Dear client, I would be happy to have the opportunity to support you on this! Based on my past experience I have had working with excel, I am sure that I will be able to issue the best possible and satisfactory solut Lagi

$30 USD dalam 2 hari
(0 Ulasan)

Hello sir, I work as an accountant and I have enough experience in Word and Excel and data entry with high speed and accuracy

$10 USD dalam sehari
(0 Ulasan)

Hi there I've read your project description and This project is perfect for me. I can start the work immediately. Waiting for your quick response. Thanks.

$20 USD dalam 7 hari
(0 Ulasan)

Hi there, I’m new on freelancer but have significant offline experience as business analyst. I’ll be happy to help you with this tusk for a symbolic price and a review.

$10 USD dalam sehari
(0 Ulasan)