Fermé

Google Sheets automatic calculations

I need to calculate (count) for specific date ranges.

Data has 4 points

1. ID

2. Start date

3. End date

4. Other data

I want to use periods (end date - start date) arbitrarily and be able to calculate what number of IDs fit those criteria.

Compétences : Excel, Google Sheets, Google Apps Scripts

Concernant le client :
( 1 commentaire ) MONTREAL, Canada

Nº du projet : #33756880

70 freelances font une offre moyenne de 23 $ pour ce travail

(1123 Commentaires)
8.3
(483 Commentaires)
7.8
daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Google Sheet and Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(171 Commentaires)
7.0
ksriniravi

Greetings! This is pretty straightforward - I can set up formulas to calculate the count for a given date range. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based ta Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(240 Commentaires)
7.0
(189 Commentaires)
6.7
(189 Commentaires)
6.7
AccountantArman

"Sir, I am Excel and Google sheet Advance Level Expert. This is a basic work for me. i can complete this project with added quality. About me I am Chartered Accountant with more than 6 years of experience from worlds Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(172 Commentaires)
6.5
best4best

Hi, It is a few minutes job for me. I am ready to finish it now. Regards MS

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(148 Commentaires)
6.4
(72 Commentaires)
5.9
(64 Commentaires)
5.4
(85 Commentaires)
5.4
IgeS

Hi there, Need to have a formula in google sheet that calculates the number of ids based on date criteria? Please message me if this is any of what you need. I'll be standing by to help. -Ige

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(46 Commentaires)
5.4
hamidr2020

Hello, I offer my services to calculate count of IDs for specific date ranges (arbitrarily) and as per criteria for other data. We can discuss further details over chat. I am an Excel / Google Sheets expert. You can ch Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(58 Commentaires)
5.5
(39 Commentaires)
4.8
rameshraja86

Hi There, I can complete this formula within few minutes. I am an experienced Freelancer for Excel Formulas and VBA development Please check my portfolio for my previous projects Contact me to proceed further Thank Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(32 Commentaires)
4.9
(25 Commentaires)
4.6
(10 Commentaires)
4.2
aruls1962

I’m a professional Engineer who has spent the past 7 years building, developing, and perfecting systems (from the ground up) through Google Sheets. With over 30 years of experience in the industry, I’ve not only learne Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(18 Commentaires)
4.1
Maherun75

"Dear employer, I had read your requirement for Google Sheets automatic calculations I am expert in this field. That's why I placed my bid on this project. I'm a professional in data entry, web scraping, data analysis, Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(11 Commentaires)
3.7
SIBTEHASSANBUTT

Hi there, I have read your project entitled “ Google Sheets automatic calculations ” I am a professional accountant dealing with PowerBi, well versed with data analytics, using excel and other data visualization platfo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(9 Commentaires)
3.6