How to calculate working days in excel excluding weekends jobs

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

...thesis, I'm in need of a 3D model and rendering for a co-working space. The project focuses on the entire building comprising 5 floors, but interior designs are only required for a few views. Key Requirements: - I'm looking for a modern style for the co-working space. - I require basic level of detailing for the 3D models and renderings, with simple textures and minimal details. The main areas to focus on for the interior views are the various workspaces within the co-working space. Ideal Skills and Experience: - Proficiency in 3D modelling software, specifically for architectural projects - Prior experience in creating basic level 3D models and renderings. The project is specifically aimed for my thesis, so I'm lo...

I'm in need of an experienced freelancer who can create a detailed model of a co-working space for presentation and visualization purposes. Key Elements: - Furniture and Layout: It is essential that the model accurately reflects the planned arrangement of workstations, collaboration areas, and other furniture. - Exterior Elevation: The model should also include an exterior view, showcasing the aesthetics and design of the building. The ideal candidate for this project should have: - Proven experience in creating detailed, realistic 3D models - sketchup Autocad plans are already there

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

I am looking for an expert to design and write a compelling commercial proposal for my IT company. The primary aim of the proposal is to pitch our photography services, offer assistance in advertising on booking platforms, and provide website design and development services for a BNB business. Key Requirements: - Crafting a professional, persuasive and detailed commercial proposal that showcases our photography, advertising and website services. - The proposal should be specifically tailored to the needs and interests of a BNB business. This involves addressing key pain points and offering innovative solutions. - A quick turnaround is essential. Ideally, the proposal should be completed within 1-2 days. Skills and Experience: - Proven track record in...

...can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purcha...

...Alpha Vantage). Store the data in a suitable format (e.g., CSV files or a database). Data Preprocessing: Clean and preprocess the collected data, handling missing values and ensuring consistent formatting. Calculate necessary technical indicators, such as moving averages (e.g., 50-day, 200-day), Relative Strength Index (RSI), and trading volume. Technical Analysis: Implement functions to identify bullish signals based on technical indicators, such as: Moving Average Crossovers: Detect when a shorter-term moving average crosses above a longer-term moving average (e.g., golden cross). RSI Oversold: Identify stocks with RSI readings below a certain threshold (e.g., 30), indicating potential oversold conditions. Volume Spikes: Identify significant increases in...

I'm looking for fresh candidates who are enthusiastic about architectural drawing. No prior experience is necessary as I'll provide you with all the n...prior experience is necessary as I'll provide you with all the necessary training and guidance. Skills and Experience: - No prior experience needed - Familiarity with AutoCAD is a big plus, but not mandatory - Strong passion for architectural drafting - Willingness to learn and grow in the field Roles and Responsibilities: - Create architectural drawings using AutoCAD - Follow my guidance and instructions for the project - Be open to feedback and willing to make necessary revisions If you're interested in starting your journey in architectural drafting and are looking for a h...

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition ...

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculatio...

I have an existing Excel macro that is predominantly used for handling formatting tasks within the Excel file. However, I need an expert who can assess and modify it to ensure compatibility with Excel for Mac 2019 or later. Key Requirements: - The existing macro primarily deals with formatting tasks within the Excel file. - The data in the Excel file is stored in both text and numerical formats. - The main change required is to update the formulas in the macro to ensure it functions smoothly on Excel for Mac 2019 or later. The ideal freelancer for this job would have prior experience with: - Excel macros and VBA - Formatting tasks in Excel - Updating or creating cross-platform Ex...

Project Description: We are seeking a talented designer to create a visually stunning, engaging, and informative page that highlights our distinctive vanilla cultivation and preparation process. The page should take viewers on an immersive journey through our vanilla's lifecycle, from the lush fields of Maroantsetra, Madagascar to the final crafting of our premium product. The designer should use the attached infographic, process flow diagram, and vanilla cut styling guide as visual references to creat our own infographic ou design steps shaping the page's content and design. These resources provide comprehensive details on our process, including key steps, techniques, timing, and quality control measures. Project Goal: The ultimate goal is to creat...

We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web

I have a PDF file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversi...

I need a proficient Matlab user who can help me Deadline: 3 days

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or crit...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform...

...developer to create a robust mobile application that offers real-time translation capabilities and includes an AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in Reac...

...bookmarks in my Google Chrome browser, two days ago. Being a macOS user and having multiple accounts on my browser, I have not tried any troubleshooting steps so far. Fortunately, I maintain a full system backup, which could be utilized for restoration. Key Points: - The disappearance of the bookmarks was sudden and unexplained, so this may require more advanced recovery methods. - Expertise in macOS is crucial, as the recovery should be compatible with this operating system. - The presence of multiple accounts on Chrome might complicate the recovery process, so understanding how to navigate this is essential. - Your deep understanding of Google Chrome's architecture is required to successfully retrieve the lost bookmarks from my full syst...

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

I'm in need of an experienced C# desktop programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedur...

...Arbitration Has Been Agreed Upon. Explanation: According to Article 8 of the UAE Arbitration Law, “1- A Court before which a dispute is brought in a matter covered by an arbitration agreement, shall declare the inadmissibility of the action, if the defendant has raised such plea before submitting any request or defence on the substance of the case, and unless the Court finds that the arbitration agreement is void or incapable of being performed. 2- Where an action referred to in the preceding Clause has been brought, the arbitration proceedings may nevertheless be commenced or continued, and an arbitral award may be made”. This provision is parallel to Article 8 of the Model Law which provides that “(1) A court before which an action ...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experienc...

I need assistance in creating Marathi subtitle files in SRT format for five separate videos on YouTube. Each video is approximately 20-25 minutes long. The subtitles should be in Marathi and match the spoken content in the videos verbatim. Non-verbal elements such as background music, sound effects, and speaker identification do not need to be included. The focus is solely on the spoken content. The freelancer shall deliver one subtitle per day and complete the project in five days.

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

I'm looking for ...for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience ...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I have an excel file, need add product categorie on a column - budget 100€

...seeking in-depth legal research covering the United States jurisdiction, with a particular focus on unfair business practices. I require expert investigation into the topic of discrimination by placing reserves on merchant accounts. Key Responsibilities: - Comprehensive analysis of the related laws and regulations in the U.S - Detailed report explaining the implications and potential consequences of these practices Ideal Candidate: - Expertise in U.S business law - Proven background in legal research, preferably with a focus on unfair business practices - Ability to understand complex legal issues and explain clearly in layman's terms This project is more than just a research task. It's a chance to create genuine impact for b...

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specifi...

Hello, I need complet the Amazon categories catalogue excel in french

...professional operations team to tailor live broadcast content and character building for you. And, there's a lot of room for growth in our job. We are also recruiting for HR, operations managers and other positions. If you have the ability, we are willing to provide positions! What are you waiting for? Come to join us! Live broadcast job requirements: computer equipment and internet in English and Portuguese and cheerful the face live Live content:  casual games. During the live broadcast, introduce the game you are playing to the audience. We provide game accounts. You only need to play for two hours and tell the audience how to play the game. Live time: Live broadcast time: 7:00-10:00 in the ...

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

We are looking for experience PHP developer who can complete the project in urgent basis, this is a tight dead line project that need to be finished in 3 days. We have an ecommerce website which is almost 90% ready, we need to add custom filter to it, below is the list of filter s: Price filter color filter Brand filter Categories filter Size filter Material filter and also fix the payment gateway error. Let me know if this can done during the weekend and in given budget I will share the code to finalize candidate.

I have a project that requires the development of a robust Android application. Key Requirements: - Development of a comprehensive Android application with 18 screens - Integration of 12-14 APIs to ensure seamless functionality - Design and implementation of a user-friendly UI/UX - Optimization for performance and security Designs, icons and api's will be provided by us Time 10 days

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

Here is your rare opportunity to make Good Money!!! Do you thrive in a fast-paced environment where your success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating that i...

I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheets...

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I need a Java Swing developer for a small project. It's a small management system. There are some future projects as well. The developer must have experience working with text files using FileReader and delimiters. It's a quick job. Please write "legal" in your bid so I know you have read the project description.

I am lookin...effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing comprehensive plans that can be used for obtaining necessary permits. Your understanding of local building codes and regulations will significantly contribute to the project's success. - Ensuring these detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to det...

I hope to acquire some apps that already exist on Google Play Store. No need for any development or optimization. Please read my requirements carefully. Key Points: - No new development is required, just purchase apps that already exist on Google Play - I'm interested in apps across a range of categories except finance and wallpapers. - The apps should offer diverse functionalities and be of high quality. - Prior experience in evaluating app performance and potential is highly desirable. - Has a certain download volume。 Your role would be to identify suitable apps for purchase, based on their category, features, and potential. Your ability to assess apps in terms of their quality, user base and potential for monetization will be crucial. Yo...

...experienced AI developer to create a robust application or website that can provide comprehensive takeoffs from uploaded residential and commercial slab plans. Key Features: * Object Detection and Text Extraction AI Capabilities - Uses advanced AI algorithms to detect and interpret various elements within the slab plans. * Supports Multiple Formats - Must be able to process JPEG and PDF formats. * Comprehensive Detail Analysis - Capability to identify and count specific components such as void formers, reinforcement bars, and structural beams. Ideal Skills and Experience: * Extensive experience in AI Development, specifically in the fields of Object Detection and Text Extraction * Demonstrable experience in creating software that can p...

I'm looking to develop an end-to-end HRMS PHP application that can efficiently manage a large workforce of over 100 employees. Project Details $30.00 – 250.00 USD HRMS Portal Development - Employee Management, Payroll Management, Time and Attendance Management We are looking for a skilled developer to build a customized HRMS portal with the following features: - Employee Management: ability to manage employee data, records, and information - Payroll Management: ability to manage payroll processing and payments - Time and Attendance Management: ability to manage employee attendance and time tracking The preferred technology stack for this project is PHP. We require moderate customization of the HRMS portal, including customizing the user...

I'm seeking a proficien...responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience...