Google Sheets Data Entry & Validation Code

In Progress Posted 1 month ago Paid on delivery
In Progress Paid on delivery

I have a start date MM/DD/YY and an end date MM/DD/YY I want a column that says whether it is "PENDING" and if it has started how many days are left "X Days Left" and if it has "FINISHED"

Excel Data Entry Data Processing PHP JavaScript

Project ID: #38863031

About the project

44 proposals Remote project Active 1 mo ago

Awarded to:

AliS233

Hey you can use the following formula in the Status column (C2): =IF(TODAY()<A2, "PENDING", IF(TODAY()<=B2, TEXT(B2-TODAY(), "#") & " Days Left", "FINISHED")) If this helped, A five star would help!

£10 GBP in 1 day
(0 Reviews)
0.0

44 freelancers are bidding on average £16 for this job

rahul62544

Hello Dan, I am Rahul, a professional freelancer experienced in Excel, PHP, JavaScript, and data processing. I can help you create a Google Sheets code to automate data entry and validation based on start and end date More

£30 GBP in 1 day
(1066 Reviews)
8.8
rahulg5466

-------------------I CAN DO IT RIGHT AWAY-------------------- ⭐⭐EXPERT IN EXCEL/G-SHEETS⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, Formulas, building an excel file, exc More

£15 GBP in 1 day
(99 Reviews)
6.0
dexdelcorp

Hey there, I came across your project and was immediately drawn to its focus on timeline-based functionality. With a strong background in web development and expertise in platforms like WordPress, Elementor, Shopify, More

£20 GBP in 1 day
(22 Reviews)
5.2
mobimubasir

Hello there I can help you to complete the project asap It’s easy job for me I’m waiting for your response to discuss further Thank you.

£20 GBP in 1 day
(58 Reviews)
5.4
Ahsan5357

Hi there, I am very much interested in your (Google Sheets Data Entry & Validation Code ) project. I've already done this kind of project before. I believe that my 5+ years of successful experience makes me highly qual More

£12 GBP in 1 day
(12 Reviews)
5.1
saim2105

As a freelancer with over five years of experience in data entry and processing, I'm intimately familiar with the challenges and intricacies of managing large amounts of information effectively. I understand how time-c More

£15 GBP in 1 day
(23 Reviews)
4.7
WebDevWang

Hi there. I can do it within 10 min using python Please contact me and get good result soon. I `m prepared here for you.

£15 GBP in 7 days
(20 Reviews)
4.7
osamaazzam66

Hi, I can help you with the project and I am ready to start now. Please award me the project so that I can start working on it immediately. I am an experienced Excel professional. If you can share the spreadsheet link, More

£11 GBP in 1 day
(16 Reviews)
3.8
ashirsabirao

Hi, You are looking for a Delivery Lead with a strong background in technology to manage digital transformation projects, ensuring timely delivery, guiding the project team, and managing stakeholder expectations. Cou More

£15 GBP in 7 days
(3 Reviews)
3.5
abhay686

With my diverse skill set, your Google Sheets work I understand I can do it in 2 hrs Please connect

£15 GBP in 1 day
(4 Reviews)
3.1
centaurusagency

⭐ Verified UAE Agency ⭐ Greeting dan263, As a senior custom website developer and Backend Expert, I can surely help you to Google Sheets Data Entry &amp; Validation Code as per your requirement with 100% job satis More

£20 GBP in 1 day
(1 Review)
2.8
MujeebSaleem2255

Hello, I’ve worked on similar projects before, helping clients like you. your project " Code validation and data entry in your google sheets document " stands out to me because it’s not just another task, it’s an oppor More

£15 GBP in 1 day
(5 Reviews)
3.0
saikishore962

As an experienced programmer specializing in Excel and JavaScript, the project you've described is right up my alley! I thrive on challenges where I have to build unique and intelligent solutions, and the dynamic calcu More

£15 GBP in 7 days
(3 Reviews)
1.1
amils7

Hi there, I propose to create a dynamic date status column that categorizes each entry as "PENDING," "X Days Left," or "FINISHED" based on the provided start and end dates. With my extensive experience in data managem More

£15 GBP in 7 days
(1 Review)
0.6
psalmson01

As a well-rounded web designer, I have developed a strong set of skills in handling data in various formats, including Google Sheets and MS Excel. Your project requirements align perfectly with my expertise as I have e More

£15 GBP in 7 days
(0 Reviews)
0.0
techstar12

As an established web and mobile app developer with a specialization in JavaScript, I have worked on numerous backend projects precisely like yours. I am up for this task, Let's connect and get started!

£15 GBP in 7 days
(0 Reviews)
0.0
eliezeraugustor

Hello @stkalvin, I understand the requirements for the Google Sheets data entry and validation task you're looking to implement. A formula can be structured to evaluate the start date and end date, providing the approp More

£15 GBP in 7 days
(1 Review)
0.0
arslan101nasir

I'm excel expert

£15 GBP in 7 days
(0 Reviews)
0.0
AhmedElsadek212

**"I am highly skilled in using spreadsheet applications such as Excel and Google Sheets to perform complex data analysis and automation tasks. With a deep understanding of functions like IF, DATEDIF, and TODAY, I can More

£15 GBP in 1 day
(0 Reviews)
0.0
amu9supe

Hello, I will create a Google Sheets script using Google Apps Script to automate the data entry and validation process. The script will check the start and end dates, and populate a column with the following: "PENDI More

£10 GBP in 5 days
(0 Reviews)
0.0