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

I'm seeking an animator skilled in producing traditional frame by frame 2D animation, to create a 30-second animation clip for my LoFi channel, with japanese anime aesthetics. The animation needs to be 30 seconds long, and it's part of a series of videos, so, it's a long term project. Ideal Skills and Experience: - Extensive experience with traditional 2D animation (Toon Boom, Procreate Dreams, etc) - Prior experience in creating short animation clips - Strong creativity and artistic skills References: Lofi Girl: My sketch:

...a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 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. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add the Contract/...

...where I need to implement the flow to send and receive invoices from a DEX vending machine on iOS. To simulate the connection to a vending machine, we are using a Redpark serial cable: With this cable, I connect to a serial/USB adapter and simulate a vending machine to try sending invoices and receiving invoice adjustments in the applications. Redpark provides an SDK() and demo software for sending and receiving data, which helps in understanding the basics. However, I am currently unable to find the correct sequence to successfully send and receive invoices to a DEX machine. I understand that there is a protocol and control characters required for communication,

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

I'm looking for a Selenium exp...Experience with testing web applications is a must. - CI/CD Understanding: While not required, familiarity with Continuous Integration/Continuous Deployment (CI/CD) pipelines would be a plus. - Attention to Detail: Ability to meticulously craft test cases and identify and report bugs is crucial. Your responsibilities will include: - Collaborating closely with our development team to understand the application structure. - Developing a suite of selenium tests to validate the application's functionality and performance. - Executing and maintaining these tests, ensuring they remain up-to-date as the application evolves. If you're a detail-oriented Selenium expert who excels at Python programming and has a passion fo...

I am looking for an experienced freelancer to conduct a detailed case study on the implementation of a Zero Trust architecture in the banking sector, analyzing the economic impact of this transition.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

Need a dev to advise on building the checkout buttons for my website, I'd prefer to use the pre-built butons for check out however I'm still looking to see how to include some custom information such as user details (for digital goods). Then on the receiving end either use IPN or similar to process that. You will need to talk me through what are the options, further work could be optional. Start your bid with "I do paypal"

...shots of three guys posing confidently. <atmosphere> - The atmosphere is playful and competitive. <voice off> "Hey TikTok fam, it's time to settle the age-old debate: Who's the most handsome among us? We're about to find out!" <Time range> (05-10 seconds): Transition with on-screen text: "Handsome Meter Challenge" <atmosphere> - The atmosphere is light-hearted and energetic. <voice off> "Alright, guys, let's head over to the app and get our faces scanned. The app will analyze our features and give us a score!" <Time range> (10-20 seconds): Shots of the guys using the app to scan their faces. Overlay of the app analyzing their features and showing scores. On-screen text showing their score...

I am looking for someone skilled in photo editing to eliminate certain individuals from my group photos. This task requires a careful and thoughtful touch to ensure that the final product looks authentic and unaffected. The People to be Removed: - Ex-partners - Ex-friends The Photos: - Group photos Ideal skills and experience include: - Advanced proficiency in photo editing software - Attention to detail - Experience with removing people from complex images - Demonstrated ability to maintain the integrity of photos after editing.

I'm looking for an audio editor who can help me with my university project. I have a series of 6 to 10 short audios that need editing. The audios are less than 30 minutes long and need to be edited in a podcast style. Key Responsibilities: - Elimination of background noise to ensure a clean listening experience - Enhancing overall audio quality - Adding relevant background music Ideal Candidate: - Experience in editing audio, particularly for podcasts - Proficient in using audio editing software - Has a good ear for audio quality - Able to incorporate music seamlessly into the background - Timely and reliable.

I need two outdoor cooking tables based on the document specs provided. I am looking for scaled, cad drawings that can be given to the custom carpenters

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

Creating a comprehensive dashboard for our POS (Point of Sale) system involves several key components and technologies. Here’s a detailed outline of the project requirements and the ideal skills needed to build the solution: Project Overview The goal is to develop a dashboard for an existing POS and inventory management system that consolidates sales and collection reports, provides inventory management, and includes customer data analysis. The dashboard should be accessible via web browsers and mobile devices. Key Features 1. Sales Reports o Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphical representation. o Data...

Hi Bratislav D., It is time for next issue of The Hot Years. Look forward to working with you. I am working on the content and hope to have it to you in next few days. Best, Mache

...expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accura...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field p...

I'm looking for a professional who can extract specific text content from a website and organize it into different categories.

I am looking for a Jinja2 frontend developer to convert our simple Figma design files into Jinja2 files. This work will prepare the files for our in-house frontend developer to im...design files into Jinja2 web templates. - Ensure the templates are well-structured, clean and easy to implement. - Implement basic functionality like navigation bars, forms, and image sliders. Ideal Skills: - Proficient in Jinja2 templating language. - Strong experience in frontend development. - Familiarity with implementing designs from Figma. - Ability to work collaboratively with our in-house frontend developer. This project is straightforward as the design is simple with just a few pages. The successful freelancer will play a crucial role in setting the foundation for the implementa...

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a to...

Hello! We're looking for an expert in Android or Flutter for an urgent project. Currently, we have the system connected on Android, but the app is lacking in many aspects. We need to connect the system on Flutter and develop the functionalities we need. In Android, we need to implement an ID confirmation and a dropdown category indicating products delivered in the main warehouse, among others. This will help us keep better control over the system. It's urgent, and we need to complete it today! If you have experience in Android or Flutter and can help us with this, please contact us as soon as possible!

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

I'm seeking a skilled video editor to assist in creating engagi...engaging Instagram Reels content. Each video will need to be between 15 to 30 seconds long and edited in a cinematic style. Ideal Skills: - Proficient in video editing software - Previous experience creating Instagram Reels - Able to understand and work in a cinematic style - Understanding of Instagram's video format and best practices - Knowledge of music selection and integration into videos The job will primarily involve editing existing video footage to create visually appealing and engaging content. You would be responsible for selecting and integrating suitable background music to complement the visuals. Your ability to work efficiently and deliver high-quality content that aligns with the cinematic...

...require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of data, so attent...

I'm looking for a skilled photo editor who can remove six palm trees from an image and fill in the space to make it appear as if they were never there. The aim is to blend the background seamlessly. Retaining high detail in the remaining parts of the picture is critical. Your expertise in photo manipulation and detail-enhancement will be a great fit for this job. High-level proficiency in using photo editing tools such as Adobe Photoshop or GIMP is essential. Strong attention to detail is also key to ensuring the picture maintains its natural look. If resolution can be increased, that is a plus. Keeping the cost down is important.

...and caps. I have about 30 designs I would like made and would like a fixed cost to create all 30 designs. They will not be complicated for the most part. Please message me for more info. Key Requirements: - The designs should be appealing to a broad audience, as they will be marketed to both men and women. - The preferred design style should be bold and humorous, with a touch of wit and creativity to engage potential customers. Ideal Skills and Experience: - Strong graphic design skills with a proven track record of creating engaging and popular designs. - Previous experience in designing merchandise, particularly for social media brands, would be a distinct advantage. - A good sense of humor and an understanding of what resonates with a diverse audience. This is...

I'm in need of someone to take the following designs and redraw them using photoshop or illustrator. It's a straightforward design. * Key Skills: 1. Graphic design 2. Logo design 3. Creative direction * Ideal Experience: 1. Have previously redesigned logos. 2. Experience in creating intricate logos. 3. Understanding of color psychology would be advantageous. Remember, I'm not necessarily out to recreate the wheel here, but I'm definitely looking for a more refined, sophisticated look.

...existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report even if...

I am in need a letter of intent from an attorney. The letter is required for me to attend the Informa Markets Fashion's Magic Sourcing Show in Las Vegas - August. Since I am starting a new business a letter of intent is required. The only requirements provided are as follows: A letter of intent from an attorney on official letterhead stating the intent to start a new business, the type of business, and anticipated date of opening. I called the show and they said that a digital copy is fine or a scanned copy.

...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experience with Exce...

I need a professional to set up an automated workflow system using Zapier for my WordPress site. The system should: - Allow me to easily upload PDF documents for conversion - Automatically create AI optimized SEO article based on the document text - Categorize the extracted content into predefined sections - Generate a structured post on my WordPress site based on the categorized content. Ideal Skills: - Proficient in Zapier and WordPress - Experience in creating automated workflows - Knowledgeable in data extraction and categorization techniques

Develop a chatbot with a web chat interface using the Llama 2 7bn LLM model to assist users in resetting their passwords. The chatbot will interact with users to collect verification details (employee number, name, date of birth, boss's name, and last four digits of cell number) through a structured conversation. The system will validate user inputs against an API and terminate the conversation after three invalid attempts. Upon successful verification, a text message with the new password will be sent via an external API. The project will include creating APIs for future speech input/output integration, ensure response times under 1.5 seconds, handle multiple simultaneous users with unique identifiers, and provide customizable response messages. The system will be deployed on ...

I am looking for a skilled professional who can take the content of my PDF book and make automations it into multiple SEO articles that will get automated post on Wordpress. These articles should be approximately 1500 words each, and should be generated automatically. Key requirements: - Understand SEO principles: The generated articles should be optimized for search engines, with appropriate keyword usage and content structures. - Automation skills: You should have experience with tools like Make or similar AI-powered software to automate the article generation process. - Attention to detail: The content should maintain the integrity of the original material, ensuring a high standard of readability and coherence. I am looking to generate several articles, so please let me know how many ...

I am seeking an expert in data entry, particul...of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed. Integrity, diligence, and meticulou...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

...April 2024. I have received communication from Amazon regarding the deactivation, mentioning that they were unable to verify the information related to my seller account or did not receive any new information regarding my listings or selling history. I require assistance in writing an appeal letter to reactivate my account. Key Points: - Account Deactivation: The account has been inactive since 25th April 2024. - Communication with Amazon: I have received a communication from Amazon regarding the deactivation. - Appeal Letter: The primary assistance needed is in crafting an appeal letter. The ideal freelancer for this project should have experience in: - Dealing with Amazon Seller Account Issues: Prior experience in reactivating Amazon seller accounts is hi...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

We want to extract members from one Facebook group which contains about 24.000 members. We don´t know if this is possible or not. We want to create a group and invite all these members to them.

I'm in need of a diligent and proactive virtual assistant. Your main responsibilities will include daily calendar ma...daily calendar management and tracking tasks in Notion. Key Duties: - **Daily Calendar Management**: Keep my calendar up-to-date and organized. - **Task Tracking**: Use a provided Notion template to monitor my progress on tasks. - **Reminder Services**: Proactively send me reminders for upcoming events and deadlines. Ideal candidates should have: - **Experience as a Virtual Assistant**: Proven ability to handle similar tasks. - **Familiarity with Notion**: Ability to navigate and use templates in Notion efficiently. - **Strong Organizational Skills**: Capable of keeping my schedule in order. - **Excellent Communication Skills**: A proactive approach to remind...

**Please read the attached job post carefully and apply if interested. This is a full-time at least 6 months contract to be renewed. An interview will be required before selecting the right candidate.** I am looking for a marketing specialist with a strong understanding of various marketing strategies and the ability to target specific audiences. The goal of the campaign is to increase brand awareness. Ideal skills for this job include: - Flyers creation - Proficiency in social media marketing, email marketing, and influencer marketing. - Experience in creating and executing multi-channel marketing campaigns. - Strong understanding of the target audience of young adults (18-24), working professionals (25-35), and parents (30-45). - Ability to analyze campaign...

I'm looking for a talented graphic designer to create a 30-inch by 36-inch poster that conveys a message in a modern style. The poster should feature a palette of pastel shades. Key Requirements: - Experience in designing posters, preferably with a focus on message conveyance - Proficiency in modern graphic design - Ability to work with a pastel color scheme.

The task consists of uploading an Angular application to AWS, its API and the database. It has to be done by anydesk and I need it now. Please write "ragnar" to see you read the post, you must be an expert in AWS. I can pay $30 for this. Thank you.

I'm in need of a professional who can transform my existing plans into a detailed HMO layout. This task involves creating comprehensive floor plans, incorporating both provided specifications and your own recommendations. Key Responsibilities: - Translate the existing plans into an HMO layout - Suggest and incorporate furniture and fixtures - Ensure the layout is detailed and accurate - Combine provided specifications with your own recommendations Ideal Skills and Experience: - Proficient in floor plan creation - Experience in designing HMO layouts - Able to accurately interpret specifications - Good eye for detail, with a focus on accuracy - Strong communication skills, particularly in providing recommendations based on requirements

Hello, I have a webpage ready designed. And a wordpress template to create the site. I need someone to put it together. And some help with finishing it. Also I need Elementer installed and cms.

I require a capable developer to create a new Python module from Wazuh server using C programming. This module should retain the following functionalities from the original: - Agent registration - Remote configuration - Log receiving A deep understanding of TLS and SHA technologies is a must.

...regulations - 3D Interior Design: providing a visual representation of the interior space - 3D rendering (1, 60-80 ft wall design, 1, 20 ft wall design) The ideal freelancer must have prior experience developing commercial engineering plans and 3D interior designs. Proficiency in relevant software for engineering and design is a must. Strong communication skills are also important as we'll need to discuss the project details and adaptations. Will need engineering plans in 2 days( I have all plumbing , electrical and mechanical information ready) Must be a certified architect. 25% payment will be made after job complete and draft shared, 25% will pay after the city approval, 50% payment will be made after completion of 3D design and rendering. Must communicate and ...

...seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.