Excel formula if date is greater than 30 days from todaydela

...intelligence and problem-solving ability over experience. I'd prefer to work with someone who is clever and learns quickly rather than someone experienced but is not very intelligent and/or does not solve problems scientifically. Would I hire an Isaac Newton or an Albert Einstein even if he had no programming experience? Of course I would. ✻ TESTS ✻ You must pass several difficult logic tests to work with me. The first logic test you complete for me will be an unpaid logic test. In other words, I would not pay you any money whatsoever if you were to pass the first logic test. However, I would pay you $25 (Twenty-Five Dollars) if you were to pass the second logic test, and $50 (Fifty Dollars) if you were to pass the third logic t...

I would like a report where a website () is currently ranked in all top search engines for specific keyword phrases Target Country is USA 1 - Accident Lawyers 2 - Truck Accident Lawyers 3 - Car Accident Lawyers 4 - Boat Accident Lawyers 5 - Construction Accident Lawyers 6 - Lyft Accident Lawyers 7 - Uber Accident Lawyers 8 - Pool Accident Lawyers 9 - Personal Injury Lawyers 10 - Motor Vehicle Accident Lawyers 11 - Personal Injury Lawyer Near Me 12 - Lawyer For Car Accident 13 - Personal Accident Lawyer 14 - Car Lawyer Accident 15 - Attorney Personal Injury Near Me 16 - Accident Lawyers Car 17 - Personal Injury Lawyer Attorney 18 - Car Accident Attorney Lawyer 19 - Accident Lawyer Near Me 20 - Lawyer For Auto Accident 21 - Personal Injury Lawyers Close to Me 22 - Family

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and effici...

I have less than 100 pages of handwritten medical notes that I need transcribed into a custom template. This project is urgent, and I require the completed transcription in less than a week. Please read this entire ad before replying. NOT FOR AUTOMATED - hand transcribing job. Key Requirements: - Transcription of less than 100 pages of handwritten medical notes and computer printouts. - Custom template formatting (specific layout or structure) - Urgent turnaround time of less than a week Ideal Skills and Experience: - Experience in medical transcription to ensure accuracy and understanding of terminology - Proficiency in creating and working with custom templates - Ability to work under pressure and meet tight deadlines So that I know you are a real ...

I am seeking a YouTube analytics expert to help improve the watch time analytics of my channel. Key Responsibilities: - Analyze current watch ti...Analyze current watch time patterns and identify areas for improvement - Provide recommendations to boost viewer engagement and retention - Suggest strategies to enhance the overall analytics of my channel Ideal Candidate: - Proven experience in improving watch time analytics on YouTube - Strong understanding of viewer behavior and engagement on the platform - Excellent data analysis skills - Up-to-date knowledge of YouTube algorithms and best practices - Experience in the entertainment content industry would be a plus Please note, I am looking for someone who can not only analyze the data but also provide actionable strategies for im...

...other navigaion organization. website address: 1. Add the content we give you to the AED battery page 2. Add content we give you to the AED pad page 3. Create an AED accessories page. 4. Make all items "clickable" and avaiable for purchase so they can be added to shopping cart. 5. Other details will be shared as we discuss the project in greater detail. - I'm keen on enhancing the overall navigation and user experience of the site. This involves improving its ease of use for visitors. I believe a smooth user experience will make the site more effective in achieving my goals. - I also need to have content added to existing pages. Particularly, I'm targeting the AED pad page, the AED battery page, and the AED accessories page. I'd like

...experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A high...

Welcome to the "From The Inside Out Wellness Center" Logo Design Challenge! We are looking for a creative and original logo design that embodies the essence of our wellness center, focusing on energy-based work and spiritual practices. Our center offers a variety of services and activities aimed at promoting holistic well-being, personal growth, and spiritual development. The design should reflect our integrative heart-centered approach, helping individuals transcend to their higher selves and empower them on their journey towards optimal health, inner peace, and spiritual enlightenment. Design Guidelines: what we consider when we assign star ratings: 1. Name of the logo must be found in the logo and it should be easily readable: From The Inside Out Wellness Cente...

I need 2 engaging 30-second commercial for my brand, Coconut Concoction. The target audience is Gen z, millennials, health enthusiasts, and coconut water lovers. The main themes to convey in the ad are refreshing and energizing, natural and organic, and promoting a healthy lifestyle. Our products focus on refreshing tender coconut water, Ice Apple, fruits, and we want to highlight their natural goodness, health benefits, and delicious flavors. The commercials should effectively convey our brand message, attract our target audience, and drive traffic to our Swiggy page and Zomato ( Food ordering platforms) . 5 Products to Feature: -Tender Coconut Juice With Ice Apple Chunks -Tender Coconut Mango Juice with Ice Apple Chunks -Tender Coconut Watermelon Juice with Ice Apple Ch...

...experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% Ho...

NOTE: MUST SUBMIT AN ACTUAL HIGH-LEVEL STRATEGY AND PLAN. I'm looking for a skilled marketing strategist who can help my company, Harmoni Innovative Tiny Homes, with our new venture: organizing date nights in our RVs. Check out Harmoni (our RV). She will be redecorated to align with our new marketing plan. Target Audience: - Young couples - Empty nesters - Adventurous singles - New couples Key Requirements: 1. Marketing Strategy: -Name (ex: Harmoni Dates/Love Camper...) -We need a comprehensive, innovative marketing strategy that appeals to our target audience. - This strategy should emphasize: - Brand awareness - Generating website traffic - Driving bookings and reservations. 2. Marketing Channels: - I would

...and gather necessary information. Write detailed, step-by-step instructions and guidelines for various CRM processes. Ensure documentation is easy to understand and follow for both new and experienced users. Organize and structure the content logically for efficient reference. Maintain consistency in writing style, tone, and formatting across all documentation. Study the agency website () to understand the services and sub-services provided. Set up a full database of minimum 30 to 40 demo clients or sample clients in the GrowCRM system, covering all stages from leads to task completion, payment, and ticket management. Create demo data from beginning to end for the demo clients to demonstrate the CRM functionality at all levels, as per the services and offerin...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

Logo needed for brand offering fundraising services for charitable causes. Designs should include iconic logo and text. *Important; only *creative and original* designs that you yourself have created should be entered. *Please do not duplicate the designs of other contestants. If a winning design has been duplicated, the award will go to the original design. > Brand name >> Causes for Caring << > Brand theme; love, caring, and charity with subtle connection to medical care > Brand Colors: We would like to see a variety of appropriate color options for the brand (see brand theme above), 2 -3 colors per design > The design should be effective in black and white as well as color > The design should be recognizable even at very small sizes > Desig...

*Notes: this project is a continuation of job description, contract & payment for Project 01. Same rules apply: https://www.freelancer.com/projects/video-editing/Creative-Talented-VIDEO-EDITOR-Needed/details Total Per Project: $250 1/3 - Deposit 30%: $75

Your task is to make a video lasting 15-45 seconds. We will provide you with the script. It doesn't matter if you have any experience in filming before. The main thing is the ability to convey the text in an interesting and convincing way, as well as show emotions such as laughter, joy, fun and a little acting. If the script requires props, they should also be shown properly. Please note that this offer is only for slovak speakers.

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

I need an expert that can help change a date on a paper receipt. I have a picture of the receipt and need someone to change the date on it. The deadline is tight, so I need this done ASAP. Ideal candidate should: - Have experience working with physical documents - Demonstrate strong attention to detail - Be able to complete the task quickly and efficiently.

I have less than 100 scanned pages of text data that need to be entered into a digital format. The scanned documents are clear and the text is legible. I am looking for a detail-oriented professional to help me with this task. Ideal skills and experience for this job include: - Proficiency in data entry - Attention to detail - Familiarity with working with scanned documents - Ability to accurately transcribe text - Time management skills to complete the task in a timely manner If you have experience in similar projects and feel confident in your abilities to complete this job efficiently, I would love to hear from you.

I'm looking for someone to help me create a list of 2000 business contacts from specific websites, particularly names, company names, position, location information, event information, number of events, current events, past events in 2024, and email addresses. I would like this list to be compiled through online research only. Key responsibilities: - Researching and compiling a list of business contacts - Ensuring all email addresses are verified and duplicates removed. Note: The focus should be on getting accurate, up-to-date information.

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

I'm seeking an expert to analyze a key aspect of my HR paper from journal with title Building organisational resilience capability in small and medium-sized enterprises: The role of high-performance work systems. The intent of the analysis is to analyse paper Key Requirements: he main structure of the analysis contains the following : Introduction Research context Methodology with results Discussion Overview Critique and significance of the paper the outcome is report and power point slides the due date is 22-5-2024

I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessa...

...Java developer with a deep understanding of e-commerce application development. The goal of this project is to build a module that calculates the estimated delivery date of the products. Key features include: - Processing Days - Transit Time - Store/Warehouses - Carrier - Estimated Delivery Date Calculation The project scope is fully detailed, providing comprehensive, clear directions about what needs to be developed, ensuring clarity and understanding. The ideal candidate should have: - Thorough understanding of Java, Spring Boot - Substantial experience in e-commerce application development - Knowledge and experience in integrating desired features, particularly an estimate delivery date calculator - Proven ability to work following detail...

...on-site exam in Nottingham, UK. This is a one-time gig with the potential for future opportunities. We provide test administration and accommodation solutions to test-takers nationwide. For this purpose, we look for professionals who we contact on an "as-needed" basis to see if they are available to assist test takers for their approved accommodations. We provide complete training and assignments pay hourly for the entire scheduled time, even if the exam ends early. We have a computer exam coming up where a test taker has been approved for a Reader and input assistance. For this assignment, you are required to be present on-site, sit with the test taker, and read the exam content aloud. You will then enter the answers as instructed by the candidate. The...

I am a content creator on YouTube launching a course in the fall of 2024, I am offering a fantastic opportunity for an experienced video editor to create an engaging and dynamic learning journey for my audience. Project Objectives: - Edit a total of ~ 25-30 videos, which will make up the lessons for the course. Video length will be anywhere from 5-15 minutes each. Total edited video content will be 3-4 hours. Footage will include 2 camera angles and potentially some b-roll of relevant information to be supplied by me. - Integrate branding assets into edits for cohesive, sleek, professional, and engaging online course videos. - Enhancing the footage with animations and effects to maintain student engagement and improve knowledge retention. This will include some on-scre...

I need to be able to create realistic tablecloth images on a table from flat images of the patterns. - Create a render template for realistic tablecloths which can be edited to change the pattern. - 2 shapes are required - rectangular and round - Ideally the table will be in a replaceable kitchen background environment - Finished image should be 4000x4000px allowing for zoom crops to be taken. - Example shape styles are attached

...extract financial data and regulatory filings from a tax website. This involves scrapping website using the provided credentials by the client, i am looking for getting the python code as i can run the code myself in the future or integrate it to another system. Key Requirements: - I need approximately 300 data points extracted. - The output for these data points should be organized into a PDF or Word. This project is about creating an automated system to generate instant reports about a company. Only difficulty is the website has drops downs to select the period involved and in those 300 data points actually many come from the same source. Ideal Skills and Experience: - Experience in web scraping (Python) - Proficient in creating PDF documents from...

I am seeking a talented logo designer to create a strong, professional logo for my restoration company. This is a Company called "RDU Restoration" Key Points: - I'm looking for a logo that reflects our company's core values of trustworthiness, reliability, and professionalism. - Our company provides a variety of services, including water damage restoration, fire damage restoration, mold remediation, and smoke damage restoration. - The logo should incorporate colors like Blue, Green, and Red - I'm open to slight variations as well. Ideal Skills and Experience: - Proven experience in logo design, particularly for companies in the service industry would be a huge plus. - Understanding of color psychology and the ability to convey trustworthiness, ...

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

Thank you!

I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but th...

...project is to stop the usage of the Sources API, which is now deprecated, and replace it with the Payment Intents API. Key Project Details: - Complete upgrade of the Stripe Bancontact integration to comply with the latest standards and to ensure the continued smooth functioning of the payment system. - Stop Sources API: The usage of the Sources API, which has been deprecated, should be removed completely as part of this upgrade. - Implement Payment Intents API as the new method for managing payments. Key Skills: - Proficiency in Stripe integration: The ideal candidate should have a strong understanding of Stripe and its various APIs, especially the Payment Intents API. Ideally with knowledge of Bancontact. Credit cards: - The payments with credit cards happens in a sim...

I need a freelancer with web scraping skills who can extract product prices and models from my 17 competitors. Ideally, the freelancer should be able to: Extract information accurately and comprehensively. Upload all the extracted information into an Excel sheet. Create a simple online website to facilitate this process. I have hosting and a domain. Enable me to update the extracted information with a single click. Complete this task within a maximum of 48 hours. Please include detailed proposals in your application on how you would approach this project.

I'm looking for an experienced SEO freelancer who can help in building quality backlinks. Key Requirements: - SEO Expertise: You should have a proven track record in SEO. - Backlink Building: You should be able to build backlinks using only the "Anchor Text". - Domain Authority: The websites the backlinks are sourced from should have a Domain Authority of 20 or higher. Please note that the target search engines and audience for this campaign are not specified. You can suggest specific websites/industries, but the decision-making will be open to discussion.

I'm looking for a skilled Shopify Public App developer to create an app for my business. The app should have the following features: - Custom Order Date Options: The ability to include unique Delivery Date options and configurations on my Shopify store. - Advanced Pickup: a customer chooses a pickup location to pick up her/his order and also uses third-party Google map API for pincode verification for pincode included or excluded for the delivery As a successful freelancer, past work is crucial. Please include examples of previous Shopify Public Apps you've developed or similar projects you have completed. This will give me a better understanding of your expertise in this area. Require Technology -> Node.js -> React.js -> Javascript -> jQuery ...

I'm looking for an experienced videographer to capture various aspects of a visit to a company HQ in London. This project will include: - Filming interior shots of the HQ - Filming interviews with employees (YouTube presenter will conduct the interviews) - Capturing B-roll footage of the surrounding area The visit date is Tuesday 18th May. The purpose of the video is to generate a YouTube video that will captivate and engage YouTube viewers. The ideal freelancer should have prior experience in corporate videography, and creating dynamic YouTube content. Please provide samples of previous work of a similar nature when applying.

I'm in need of a competent web developer to craft a straightforward website for my courier business. The site will be primarily focused on providing clients with pack...website for my courier business. The site will be primarily focused on providing clients with package tracking information. Key Website Pages: - Home Page: This will feature my company's logo, name, and contact information. - Tracking Page: This is where clients can input their tracking number to see the current status of their package. It should also display an estimated delivery date. The ideal freelancer for this project should have experience in web development and a strong understanding of user experience design. A good communication skill is also preferred, as I'd like to be updat...

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Pagamento ordine" and "Rimborso". Make the sum using the formula in column J "totale ordine" of the attached “esempio output” file 2- Filter the rows of input file 2 (attached), column D "Dettagli prodotto" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "dettagli prodotto”of input file column 2 are listed. (example VAT file attached) 3- ...

Ben Arda, aktif olarak yeni iş fırsatları arayan biriyim. Canlı destek hizmetlerinde 6 aydır çalışıyorum ve bu süre zarfında müşteri memnuniyeti, marka değeri koruma ve doğru üslup kullanımı konularında derinlemesine tecrübe edindim. Esnek çalışma saatlerine uyum sağlayabilme kabiliyetim ve hızlı, etkili çözüm üretme yeteneğimle ekibinize değer katabileceğime inanıyorum. İletişim becerilerim ve problem çözme yeteneklerimle müşterilerinizi en iyi şekilde desteklemeye hazırım. Güvenilir bir hizmet sunarak, işinizi bir adım öteye taşımak için iş ilanlarını değerlendiriyorum.

Domain Authority => 30+ Page Authority => 35+ URL Rating => 70+ Domain Rating => 70+ Trust Flow => 40+ Citation Flow => 35+

I'm seeking a skilled designer who can create a multiple business logos from WWII era vintage-styled military art combined with modern day technology. It should be crafted in color, eliciting a classic yet modern feel. If you specialize in vintage designs and or blending multiple design elements together, this project may be an excellent fit for you. Key skills required: - Expertise in vintage logo designs - Creativity in using abstract geometric shapes - Ability to work with color palettes.

We have a non-trivial design built in Figma. We need a WordPress theme built to match that design. The desktop version is ready. This job also includes building the mobile version, according to what our designer will create soon in Figma. See the attached document for our requirements, as there are some details there.

I am seeking a creative and experienced video editor to create a captivating YouTube introduction video to increase the average view duration of my posted content. This video is primarily targeted at young adults and business professionals. - Objective: The aim is to create a video that will hook my viewers, encouraging them to watch more of my posted videos, hence increasing the average view duration. - Video Content: The video will be repurposed from the original recording. - Desired Video Length: The video should be anywhere from 30 seconds to 1 minute long, capturing the audience's interest from the get-go. Ideal Skills: - Experienced with video editing in line with YouTube's format and general style. - Ability to create content tha...

**About the Role** We are currently seeking a highly skilled Front-End Developer with a strong focus in React(using Typescript) and a minimum of 12+ months of experience in creating web applications. You will be responsible for the development, design, and implementation of our new website's front-end aspects. This is a **6-month contract** position with a competitive hourly rate. **Key Responsibilities** - Developing new user-facing features using React.js and Typescript - Building reusable components and front-end libraries for future use - Familiarity with RESTful APIs and integrating front-end with back-end services. - Optimizing components for maximum performance across a vast array of web-capable devices and browsers - Implementing an intuitive user interface - Design...

... -Strong knowledge of Shopify and its functionalities. -Excellent research skills and the ability to stay up-to-date with industry trends. -Exceptional copywriting skills with a keen eye for detail. -Strong organizational and time management skills. -Ability to work independently and meet deadlines. -Strong communication skills and a customer-focused mindset. Contract Details: -Duration: 6 months (July 2024 - December 2024) -Payment: Monthly payments, rate to be discussed based on experience. -Renewal: Opportunity for contract renewal in 2025 based on performance. If you are passionate about skincare, digital marketing, and creating engaging content, we would love to hear from you! Please submit your resume, a brief cover letter explaining why you are the ideal ca...

I’m on the hunt for a highly professional and reliable commercial cleaning service that can maintain my premise three days a week. The exact square footage of the commercial space was not provided, hence a site visit may be required to assess the area. You should have: - Proven experience in commercial cleaning - The ability to set and adhere to a cleaning schedule - The ability to handle a wide range of commercial cleaning tasks - Exceptional attention to detail The ideal candidate is someone consistent in delivering top-notch service and understands the unique concerns in cleaning commercial spaces. Looking forward to a sparkling clean working environment! I will supply my own cleaning products for this contract

...some design work. Budget is fixed (if you ask for more, you will be blocked and if you bid over the amount in the project, your bid will be hidden), and I will discuss everything via private message. I am looking for a dev to start today on this and would like it done by tomorrow. It is not terribly hard work or that time consuming. I will provide logins only once I have awarded. I am not giving out logins ahead of time. If you ask during the messaging process, you will be blocked. Also, I anticipate that quite a few will be capable of completing this task. If I reach out to you, after I send the project details, you must explain to me why you are the one I should pick. You are welcome to ask questions in there but I have been very thorou...

I'm in need of a freelance writer to craft an engaging, informative article on boardrooms. The key aim is to provide general information for the public. Key Requirements: - The article should cover a detailed explanation of the full function of a boardroom. - It must be educational yet engaging, appealing to a wide audience. - The focus should be on clarity and simplicity, making complex concepts easily understandable. - I will need a turnaround time of 4 days. - Needs to be between 1,500 and 1,800 words - Must use 3 to 5 references in the article that will be provided upon awarding of the project. Ideal Skills and Experience: - Proven experience in creating engaging, informative articles. - Good understanding of business terminologies, specifically boardroom function...

I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed