Excel formula if date is greater than 30 days from todaydela

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.

I need a seasoned legal expert to draft a Letter of Demand for a real estate transaction in Singapore. Key Project Details: - We're a Wyoming registered company. - The purpose of the letter is to threaten legal action. - The recipient is an individual. - The letter must be completed within 2 days. The ideal candidate should: - Have prior experience in drafting Letters of Demand. - Possess excellent communication and language skills. - Work efficiently under tight deadlines. You will acting in the capacity of our in-house legal counsel or in the capacity of a lawyer representing the company. The letter will have to be drafted and signed by you. You should be a qualified attorney and must be able to represent a Wyoming registered firm. Please contact us for ...

...5" iPhone 5.5" iPad 13" iPad 12.9" Screenshots must be taken directly from each device; resizing from other screenshots is not acceptable. Ensure all screenshots comply with the guidelines of both Google Play and the Apple App Store. Screenshots should highlight the main features and unique selling points of the app. Videos: Android: Record 2 demonstration videos showcasing the app's functionalities, each between 30 seconds to 1 minute long. iOS: Record 3 demonstration videos for each device size (iPhone and iPad), each between 30 seconds to 1 minute long. Total of 15 videos (3 for each iPhone size: 6.7", 6.5", 5.5" and 3 for each iPad size: 13", 12.9"). Videos should be of high quality, with clear vis...

I'm looking for a professional, modern and elegant logo design for my business, City Nest Living. I'm open to any colour scheme, so ...dated or overly traditional design elements. - Elegant: I want the logo to have a touch of sophistication and refinement. It should be stylish and classy, without being too flashy. - The company name must be included in the logo Ideal skills and experience: - A strong portfolio with a history of successful logo designs, particularly for professional services or real estate businesses. - Up-to-date knowledge of design trends, particularly in the field of branding and logo design. - Excellent communication skills to understand and incorporate my vision into the design. - Ability to work efficiently and deliver high-quality work within a re...

App updates with these issues will be rejected App must target Android 13 (API level 33) or higher Enforced Aug 30, 2023 Warning sent Aug 10, 2023

...experienced PowerBI solution architect to provide expert guidance on setting up and creating PowerBI reports for our customers. Our goal is to develop a robust reporting strategy that ensures our clients can easily consume and utilize these reports. We need a professional who can help us understand the requirements, best practices, and strategic approach to initiate this project. Objective: To gain insights and guidance on starting with PowerBI reporting, understanding the necessary requirements, and developing a strategic plan for implementation. Duration: 30-minute consultation call Experience: Proven experience with PowerBI report creation and strategy development is required. A clear understanding of the steps required to start with PowerBI reporting. Identifi...

I'm looking for a dedicated and knowledgeable curriculum developer to create a comprehensive course on Post Natal Care. The curriculum is intended for vocational training, focusing on the essential skills and techniques related to post natal care for both new mothers and their babies, with a touch of basic nursing and massage therapy. Key Responsibilities: - Develop an engaging and structured curriculum that covers the fundamentals of post natal care - Incorporate basic nursing skills relevant to post natal care - Integrate safe and effective massage therapy techniques beneficial to new mothers and their infants - Ensure the curriculum is tailored to a vocational training audience, with a practical and hands-on approach. Ideal Candidate: - Proven experience...

We will do only foundation with reinforcement as per sample we have will need $800 and 2 days.

- Moving from Iubenda to Mirasvit (I will buy and install extension) - Fixing Alpinejs and Google consent exceptions (as seen on Firefox), double check exceptions cross browser. - Check Mageplaza blog (): for example it seems that is needed by extension, I removed it because is useless in frontend, but need to be double checked.

...Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions are from primary school level math exams, so a good understanding of these topics is crucial. - You will need to effectively categorize each question based on the specific skills that need to be applied to solve them. - Proficiency in creating detailed digital reports is a mus...

Hello, I will need 2 different versions of a very simple booking android app. the important part is the communication with our simple Java (eclipse) backend. Analytical step-by-step details will be sent in doc, together with helpful code and matterial, as well as the java eclipse project of the backend. We will need 2 completely different versions of the same app (completely different gui, comments on code, approach where possibble, all variable and function names, structure and order) Budget is $200 USD for both (2 milestones $140 USD and $60 USD) Deadline: 27/5 for the first and 30/5 for the second

...that can extract specific text content from a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with working with databases, especially CSV or Excel f...

I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge of income tax laws and ...

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

Hello, I'm looking for a professional developer who can create an app for ...professional developer who can create an app for Android camera that can receive live video streams from OBS and broadcast them directly onto the primary screen of the smartphone's camera. The app should be able to convert the stream sent from OBS into a format compatible with the phone's primary camera and display it in high quality. The app should be capable of playing the video directly without the need for an external application, but I need a skilled developer with experience in integrating with OBS and efficiently programming the app. The app should be compatible with the latest versions of the Android operating system. Please provide a detailed quote along with a timeline for de...

I'm looking for a talented abstract artist based IN BELGIUM or FRANCE, !!! to create a unique pen and ink tradi...abstract artist based IN BELGIUM or FRANCE, !!! to create a unique pen and ink traditional hand made drawing for me ( fits inside A4). the concept is on the photos more explanation done via dm's Key Requirements: - You must be based in Belgium, as I prefer to receive the final drawing via post. - Proficient in pen and ink drawings (hand drawn, traditional), with a strong portfolio in the abstract style. - Should have a deep understanding of fantasy themes, with a particular focus on 'Lord of the Rings'. If you think you have the skills and creativity to bring this vision to life, please don't hesitate to apply. Thank you. deadline: one ...

...but work is increasing so I am looking for a second one. A plus if you can do video editing or graphic design. I need a fully bilingual professional (I will interview in English via video) to do some tasks for my agency, such as: Social media Content editing or creating CRM management Email marketing Writing an ebook Researching Organizing data in spreadsheets Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must be a FAST learner, attentive to details, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes over and over. Attention to detail. Common sense. This job will part-time as a test period, after that it will be full-time...

Hi. On my shopify website the links tot the product page have gone missing. I need to urgently correct this. I also need to urgently set up another page titled events, and list two events on there like you would a product in the womenswear section. Can someone help with this today? I need it resolved by 5pm/Irish time. Thank you. Kind regards, Angela

...to prioritize speed optimization as a primary focus for improvement. Few Days Work - Maybe One Day. Key Tasks: - Identify bottlenecks that are causing slow performance - Implement solutions to enhance server performance - Recommendations on security and downtime prevention Ideal Freelancer: - Proven experience in Linux server infrastructure maintenance - Proficient in diagnosing and resolving issues related to server performance - Familiarity with security measures for server systems - Reliable professional with a track record of improving server performance and reducing downtime. Key Responsibilities: - Securing our network: Identifying and implementing necessary security measures to ensure our network is safe and resistant to cyber attacks. - Monitoring our net...

More details: What is the primary purpose of the swiping functionality/screen in your app? Event browsing What content should be displayed on each swipe card? Event name and photo, Event description and date, Event location, Host photo How should the swiping functionality work? Swipe left to dislike, swipe right to like, Swipe up to view more details, swipe down to return to previous card Add swipe screen to menu on existing app, populate with dummy data, that calls backend api