Excel formula if date is greater than 30 days from today jobs

...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'm looking to set up a platform where I can sell digital products. Key Requirements: - I'd like customers to be able to download their purchased products directly after they make a purchase. - The platform should support cryptocurrency payments for the purchases. Ideal Skills and Experience: - Experience in setting up online sales platforms, preferably for digital products. - Knowledge of cryptocurrency payment systems. - Understanding of user-friendly download processes for customers. Please let me know your experience in this area and how you would approach this project.

**NO OR LIMITED EXPERIENCE IS OK - FEEL FREE TO APPLY. DO NOT USE GENERIC BID TEXT (NO COPY PASTING)*** Role is perfect for motivated and learning individuals who are eager for feedback and want to grow skills. Duration is 30 days internship. Those who surpass expectations will receive a serious offer to stay on team with better compensation. Sample tasks and responsibilities include, and are NOT limited to: 1. Research key topics or areas of interest and presenting options for the next steps. -> googling 2. Executing next steps and promptly executing action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details inc...

I'm seeking a ...groups. Key tasks involved: • Coding data sets on MAXQDA • Analyzing coded data • Delivering insightful interpretations of results The job will involve approximately 40 surveys, 12 interviews, and 2 focus groups. It's therefore crucial that the successful individual or team is able to perform this task efficiently, maintaining high-quality data analysis throughout. Having previous experience in a similar job, and professional knowledge of Windows operating system, is highly desirable. Therefore, this job is best suited for someone with a strong understanding of MAXQDA projects, an analytical mindset, detail-oriented with exceptional organizational skills and a proficiency in Windows. Prior experience in handling such a ...

Key Responsibilities: - Secure Discounted Air Freight Rates Per 1 Kilogram: I need someone who can use their industry knowledge and connections to secure the most competitive air freight rates while maintaining the quality of delivery services. The air-shipping rate we’re looking for is $5 per 1 kilogram. - Air-Shipping Time Duration: We’re looking for air-shipping time duration between 1-14 days. - Final Destinations: To make sure the shipping company can deliver the product from China till our clients doorsteps in GCC countries. - Efficient Handling Of Electronics & Clothes: You should be well-versed in handling electronic goods and clothes to ensure they reach their destination in optimal condition. - In-Depth Knowledge Of GCC Customs Regulations...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

Need help with fixing hacked wordpress page. It opens normally but when try to open via google search some russian webpage appear. Need cleaning. Today only!!!

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

I'm looking for a WordPress expert who can help me resolve an Error 500 issue that's occurring when users access my website. The error seems to be an 'Internal Server Error', but I'm not sure what's causing it or how to fix it. Key Tasks: - Id...outdated nextend-smart-slider3-pro inside: ./wp-content/plugins/nextend-smart-slider3-pro/ - Version: 3.5.1.21- Please update asap. New Version: 3.5.1.23 Warning: Found outdated advanced-custom-fields-pro inside: ./wp-content/plugins/advanced-custom-fields-pro/ - Version: 6.2.9- Please update asap. New Version: 6.2.10 -------------------------------- Out of date software is the most common cause of website compromise. It's highly recommended to get that updated as soon as you can. Can this above...

I'm looking for a skilled photo editor who can completely remove sun rays from an outdoor photo featuring a motorcycle and a person. Your expertise in professional photo editing and manipulation will be crucial to achieving a flawless end result. Here are my requirements: - Complete removal of sun rays from the image. - Retain the overall quality and integrity of the image while executing the task. - Experience working with outdoor photography and dealing with lighting elements. - Excellent attention to detail to ensure a natural look after removal. - The ability to work efficiently to deliver the project within the agreed timeframes.

We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Res...of keyword research tools and SEO optimization techniques specific to YouTube. - Proficiency in utilizing analytics tools to drive decisions and enhance content performance. - Strong creative skills for developing eye-catching thumbnails and titles. - Passionate about the YouTube platform and staying up-to-date with the latest trends and algorithm changes. If you're ready to join a results-driven team and help businesses across various industries excel on YouTube, we'd love to hear from you. A perfect opportunity ...

On-page: Improve the header, mobile version, and add a footer. Create blogs similar to but we'll provide the keywords. In your bid, mention how many blogs can you provide with the bid price. 200 Do-follow High Quality backlinks from PR3-Pr4 Sites with at least DA 30+: A final report will be provided by you with links, website name, DA and PR values on a list. Error Free list Note: No backlink from social media sites, forum, comments, directory, listing, or SEO driven site.

...or Free) New Session page: where the student can select Subject & Topic, and mention questions if required. Then, Instructor Selection Phase: An interface to let students select a suitable instructor, for their subjects based on the instructor's predetermined disciplines, then select date/time according to Instructor's calendar availability. There is an ability for the student to schedule a set of sessions for a whole subject or many subjects, with a specific Instructor, then determine date/time according to the Instructor Calendar. The Student who created the session, can also invite other students to his created session(s), in this case the Cost is different & shared. The Online Session: It is an online video lectures, whe...

...particular priests. Key Features: - User Registration and Login: The platform should provide a seamless registration and login process to users. - Search and Filter for Priests: Users should be able to easily search and filter for priests based on location, preferred language, and availability. - Booking and Scheduling System: An efficient booking and scheduling system is required. This should allow users to select their preferred date and time for the service or event, receive confirmation and reminder notifications, and make payments online. Ideal Skills and Experience: - Proficiency in front and back-end development - Experience in building user-friendly interfaces for seamless user experiences - Strong knowledge of search and filter functionalities - Previous exper...

Please Sign Up or Login to see details.

...am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (c...

I'm in need of an experienced video editor who can creatively stitch together attractive Instagram reels for a gym-foc...to incorporate background music that suitably matches the tone of the video. - Ability to create reels that are primarily more than 30 seconds in duration. The content focus will be on producing engaging videos for our gym. It's critical that the editor knows how to best highlight the best qualities of the gym, thus compeling other potential gym-goers to join our community. The ideal freelancer should have a strong portfolio of editing Instagram reels, preferably in the fitness or wellness industry. This project requires not just technical skills but also creativity and a knack for storytelling. Familiarity with Instagram's audience eng...

I have a photo of a medal that I would like to have converted to a svg file for printing. I want the outlines of the kings head, text and contours in black. Also the clasp with the text *1858 Gustaf V †1950 in black. The ribbon should be black also. Show examples and the best one gets the job.

Start date of contract: June 15, 2024 Termination date of contract: open ended Hours per week: up to 20 hours per week Rate of pay & Currency: USD 15.00 per hour Supervisor: Janet Sun Work to be performed: Data review and data entry tasks, as assigned by Janet Sun and Mel Hennigan

I need a skilled drafter to create a detailed CMU wall reinforcing and grouting shop drawing based on an architectural drawing. Please find the specifics below: - The shop drawing needs to include Horizontal reinforcement, Vertical reinforcement, and Grouting details in 2 or 3 pages -Ideal candidates for this job should have prior experience in similar projects -I will send you architectura...to create a detailed CMU wall reinforcing and grouting shop drawing based on an architectural drawing. Please find the specifics below: - The shop drawing needs to include Horizontal reinforcement, Vertical reinforcement, and Grouting details in 2 or 3 pages -Ideal candidates for this job should have prior experience in similar projects -I will send you architectural drawing. -I need this in 2 ...

I am looking to establish a long-term relationship with a talented person to scrap thousands of dating profiles from popular dating websites. This person should have years of experience dealing with the various countermeasures these sites will employ to discourage scraping. The use of proxies may be needed to achieve satisfactory results. The end goal to to have a system capable of delivering 20K - 40K profiles per day.

I'm in search of a di...Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and accuracy are highly valued. - Understanding of basic financial jargon will be beneficial. This role requires someone who is organized, reliable and able to work independently. The workload will be part-time with flexible hours. If you're a self-starter with a strong work ethic and you'...

...**Improved Organization**: The primary goal of this project is to enhance my overall financial organization. - **Investment Tracking**: A secondary but important aspect is to have a system in place for monitoring and evaluating my investment performance. Ideal Freelancer: - **Accounting and Bookkeeping Expertise**: Strong background in personal finance and investment bookkeeping is essential. - **Software Proficiency**: Experience in working with personal finance software is highly preferred. - **Organization Skills**: Ability to set up an intuitive and efficient system for tracking and managing my finances. The successful candidate will be able to streamline my personal financial tracking, ensure the data is organized and up-to-date, and crea...

I'm in need of a skilled UI/UX designer who can create a mobile interface that's minimalistic and modern while prioritizing user engagement, ease of use, and brand consistency. JOB DESCRIPTION FIXED BUDGET Stage 1: UI/UX Research - $30 Research and ideation: Analyze similar apps. Conduct qualitative and quantitative surveys. User flow: Develop flows for key features. Stage 2: UI Style Guide - $15 Includes typography, icons, and colour schemes. Stage 3: Screen Design Simple Screens (e.g., Onboarding, SplashScreen, Login): $5 each Medium Complexity Screens (e.g., Account page): $15 each

Please Sign Up or Login to see details.

...(see screenshot) Post A post can take 3 forms: - static weight text (ie. 71.3, ^0.5 - where the latter is the weight gained compared to the previous logged weight) (see screenshot) - a photo (see screenshot) - date (ie May 19) (see screenshot) Post interaction - Posts can be deleted or be created Gallery conditions - Displays rows of 5 thumbnails (see screenshot) - If it is the first post of the day, the gallery adds a thumbnail of today's date before adding the actual post (see screenshot) Post condition static weight text - If the weight is equal to the previous logged weight (or if it is the first weight), give it an orange background color (see screenshot) - If the weight is lower than the p...

...conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use googl...

...involves setting up a Python script that can scrape a popular review site. Key details to extract: - Review text - Star rating - Date of review - Reviewer name - Star-ratings for sub-categories - Review ID - Reviewed person - Reviewed product name The site does not use captchas, so it should be reasonably straightforward. All reviews for a given provider should be scraped. It would be good to have an option to start with the newest and stop at a certain date. The specific review site can be seen in the sample URL in the attached PDF. I can send further details in a private message including screenshots. Preferred frameworks would be Beautifoulsoup 4 / Scrapy if sufficient and Selenium otherwise. Please state which one you plan to use. Note: it should be possib...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is...

...app. Technical Specifications: Develop detailed technical specifications and project timelines. 2. Data Collection and Preparation Data Gathering: Collect relevant datasets, including patient histories, lab results, symptoms, and lifestyle information from current database Data Cleaning: Preprocess the data to ensure it is clean, consistent, and free of errors. Data Annotation: Label the data appropriately for training machine learning models. 3. Model Development Feature Engineering: Identify and create relevant features from the raw data that will be used to train the machine learning models. Algorithm Selection: Choose appropriate machine learning algorithms (e.g., decision trees, neural networks) for the task. Model Training: Train the models using...

...timeframe. Bids: Please provide 3 links to your recent MERN/MEAN projects and provide some documentation or proof that you were the original developer of those 3 websites please. Tech: Front-end Framework: React.js with and State Management + Typescript Styling: Tailwind CSS Back-end Framework: Node.js with Database: MongoDB Goals: Build a cryptocurrency gambling website from PSD + Figma designs and requirements provided and discussed (google docs/sheets). Must be fully secure and fully tested with no bugs or issues. Experience Needed: - Previous experience with Full Nodes ("Bitcoin Core" for Bitcoin and "Geth" or others for Ethereum) + understanding smart contracts - Previous experience making Desktop/Mobile responsive websites - Previous experienc...

I have a mix of digital and paper cell records from Google Take Out that need to be converted into an easily searchable and readable format. Key points: - Data formats: Both digital and paper - Required output: PDF document - Analysis: I need you to analyze the number patterns for this data, specifically looking at numbers used once versus those repeated over multiple years. This analysis should be done thoroughly and presented in a clear, easy-to-understand manner. Ideal freelancer skills and experience: - Proficient in data conversion and organization - Skilled in creating and working with PDF documents - Experience in data analysis, especially patterns and number analysis - Ability to create visual representations, such as charts and graphs - Strong attention to detail and acc...

I need a WordPress website developed from my Figma design. The design is complete and I need the site to be an exact match. Key requirements: - Convert Figma design to a fully functional WordPress website. - Ensure that the website design is pixel-perfect. - Adhere to provided color scheme and branding guidelines. Ideal Skills and Experience: - Proficiency in both Figma and WordPress is a must. - Experience with Cpanel hosting. - Strong understanding of responsive design for different devices. - Attention to detail to ensure the design is exactly matched. PLS NOTE: This is an urgent project to he started today and delivered by Sunday. I cant accept any bid that does not comment on figma to wp experience.

I'm in need of a talented lead sourcer who can help me find leads. TARGET: -> is in the coaching industry based in France, Swizerland, Belgium and Luxembourg -> speaks French. -> coach in business, life, or health -> has a yearly revenue between 50k and 500k EUR DATA needed: -> First Name, Last Name -> Website URL -> Social Media Accounts -> Email Addresses Please indicate the number of leads you can source along with your price. BUDGET FOR THIS TEST PROJECT IS LESS THAN 30 EUR.

... - Selection of a suitable photo shoot date - Selection of additional photo shoot services - Short-term storage of photos - Allowing the real estate agent to download the resulting photos via API - Everyone will see the photos they have permission to. He will be able to filter and sort them on a basic basis - Photographer rating system System users: - Broker ◦ Establishes a request for a photo shoot ◦ Selects the date and service ◦ Sees his orders including the resulting photos ◦ Evaluates - Photographer ◦ Sees assigned jobs with a schedule (calendar) of jobs ◦ Confirms the job ◦ Inserts the resulting photos ◦ Sees your historical orders as well Here is the necessary scr...

...who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source material, with the primary emphasis on the collation/assembly into the required format. An example of the required spreadsheet format is ava...

I’m looking for Telugu speaking video editor since the project is about editing promotional podcast video for upcoming social network app … i want editor to use motion graphics and app UI screen while the speaker saying his line accordingly Il will be providing podcast video footage and app UI screen videos as well I'm in need of a talented video editor to work on my podcast episodes. The primary task will be to incorporate graphics and text overlays into the video content. Key Responsibilities: - Video Editing: You will be responsible for editing the video content of each episode. - Graphic and Text Overlays: Incorporating graphics and text overlays into the video to enhance the visual appeal and convey information more effectively. Ideal Skills and Experience...

I have a large set of handwritten notes that need to be accurately transcribed into digital format. I...large set of handwritten notes that need to be accurately transcribed into digital format. I need someone who is meticulous and has a keen eye for detail, as the work needs to be done with no errors. Key Requirements: - Type of Job: Data Entry - Data Format: Handwritten notes - Level of Accuracy: Very High (no errors acceptable) Ideal Skills: - Proficient in typing - Detail-oriented - Experience in data entry, particularly with handwritten notes - Ability to follow instructions accurately and efficiently Your task is to convert these notes into a digital format, ensuring every detail is captured accurately. Your attention to detail and commitment to producing err...

We are seeking a skilled and creative graphic designer to create an engaging and informative flyer for our 6-week sports program titled "Unleashing The Champion Within: The Athlete's Mindset". This program is designed to elevate the skills of aspiring football athletes through structured training sessions focusing on physical, mental, and tactical growth. **Header:** - **Program Name:** Unleashing The Champion Within: The Athlete's Mindset - **Subtitle:** Transform Your Game, Mind, and Body in Just 6 Weeks **Body Section:** 1. **Introduction** (Brief overview): - **Text:** "Join our exclusive 6-week program designed to unleash your potential as an athlete. With a focus on football training, mental resilience, and physical conditioning, you're set ...

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

Anyone who quotes above budget will be disqualified immediately. Bid only if you are available to start work today. Must Read the attachment before bidding. You must submit your relevant work history as soon as you submit your bid not to disqualify. I'm looking for someone with demonstrable cAlgo experience ( Must share previous work samples and also show me live evidence on a video call to be considered eligible) to code my indicator-based simple bot within 5 days. Feel free to suggest if any of my requirements are difficult for your skill level and I can consider them. Those who don't reply to msgs for more than 15 minutes will not be eligible as they are not reliable to work with.

Create a design for a product listing on Amazon. The product is a cover for a towbar. You can find the full description in the assignment in PDF format. Deadline - 7 days

I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bi...

...for a talented and experienced freelance designer who can help me bring a children's book to life. The book is intended for school-aged children (6-12 years old) and has an educational theme. The key tasks/requirements include, but are not limited to: - Book design for a 30 page children's book - Creating engaging, educational, and age-appropriate illustrations - Following an educational style of illustration that will appeal to children Skills & Experience required: - Proven experience in children's book design - A portfolio demonstrating skills in creating engaging, educational illustrations - Excellent understanding of age-appropriate design and layout - Attention to detail If you have the skills and experience I'm looking for, pl...

Experienced UX/UI designer with a strong background in Figma and current design trends wanted to work on a web app project. KEY RESPONSIBILITIES: - Design up to 20 standalone desktop screens or 30 mobile screens monthly - Convert sketches and wireframes into finished mockups - Create visually stunning and intuitive interfaces that enhance user experience - Collaborate with the team to brainstorm ideas then turn concepts into user-friendly interfaces - Redesign desktop screens for mobile responsiveness - Proactively provide creative solutions and improvements to existing designs and user flows - Please include the key word 'Lavender' in your bid to indicate you actually read the brief CANDIDATE REQUIREMENTS: The candidate should... - Be creative - Have strong Figma ski...

I am in need of a creative professional to bring to life my vision of a futuristic, menacing, left-handed themed 'Warzone' for my upcoming hard/dark tech...information hub for the event Ideally, you should have a solid background in graphic design and web development. A passion for techno music and an understanding of its culture would greatly be advantageous. Website includes: - Event Details: Date, Location, Line-up, etc. - Artist Profiles: Background information and links to music Creativity is key here, and the capacity to incite a sense of anticipation with a 'coming soon' element would greatly appeal to potential attendees. Comprehending and capturing the spirit of menacing, hard/dark techno is vital. Together, let's create a thrillin...

Hi, We are currently looking for a talented react native developer to help us deliver our first notifications app for iphone and and...notifications app for iphone and android. We are a web-development company that has developed a community platform that connects people and encourages them to support each other through sharing time, knowledge and support. We are looking for responses to our brief to understand the cost and time to deliver an app that will keep our community members up to date with all their community notifications. We have attached a brief and here is a link to link to an overview video: We’d love to receive responses by Wednesday the 29th May and we will aim to select a developer to work with shortly after. Best wishes

I need an expert in Optical Character Recognition (OCR) technology to convert text from high-resolution, clear photographs to editable text. Key Project Details: - **Purpose**: The primary objective of this task is to extract data from various documents. - **Image Type**: The text extraction will specifically be from photographs of text. - **Image Quality**: All photographs are high resolution and clear. Ideal Skills and Experience: - Proficient in Optical Character Recognition (OCR) technology - Prior experience in extracting data from images - Excellent attention to detail to ensure accurate transcription - Ability to work efficiently with high-resolution images

...people to do tiktok live stream selling, include register an account and then do online selling, we need you to be able to seek people and bring them into a group to do this. As a manager, you need to prepare an action plan about how to do this in your country, and effective way to manage people. - We need assistant who can help us to increase Facebook group members for our good deals offers, which is much lower price compared with the market price product, that we want you to be able to get more people into this group, and maintain a daily management based on this Facebook group. You need to let us know your hourly rate, or get us an effective action plan of this as well. Some other: - Weekly calendar management: You'll be responsible for organizing and scheduling appointm...