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

Project Title: Basic Audio Note ...accounts and login system Ability to upload audio files (3 seconds max) - MP3 format preferred Option to add simple labels (e.g., "Meeting Notes," "Quote") to each audio file Ability to sort and filter audio files by upload date or label Basic interface for browsing and listening to uploaded audio files Secure storage of user data (audio files and labels) Target Audience: This app caters to users who want a simple way to organize and access short audio snippets for personal use. Think of it as a basic audio version of a text-based note-taking app. Please Note: This is a very basic project focused solely on functionality. No need for fancy features like audio editing, playback speed control, or file sharing. Design aest...

...in need of an experienced Email Marketing Specialist to help me roll out and manage a consistent email marketing campaign for my Product A. - Product: I'm focusing solely on the promotion of Product A through email marketing. - Target Audience: The campaign will be targeting individuals in the age range of 30 to 65. These consumers should fit the profile of the typical email user who is interested in purchasing products online. - Objectives: The primary goal of this campaign is to increase sales of Product A. However, I am also looking to use this campaign to build brand awareness and drive traffic to my website. The ideal candidate for this position should have a strong background in email marketing, especially in relation to e-commerce. They should h...

We're on the hunt for the perfect company or individual to lead ...mobile app space. • Strong Portfolio: A diverse portfolio showcasing a range of creative content and successful campaign outcomes. • Industry Knowledge: Up-to-date with the latest trends and best practices on TikTok, Twitter, and Instagram. • Innovative Thinker: Ability to think creatively and strategically to produce viral content that stands out in a crowded digital landscape. • Communicative and Collaborative: Excellent communication skills and a collaborative approach to work closely with our team. If you're ready to make a splash in the social media world and have the skills to drive a successful campaign, we want to hear from you! Submit your proposal, including your...

I am looking for a freelancer who can help me implement a meta ad service on Facebook Ads. Target Audience: - I have a specific demographic in mind for my ads. Budget: - My expected budget for this service is less Skills and Experience: - Experience in implementing meta ad services on Facebook Ads - Strong understanding of targeting specific demographics - Ability to work within a limited budget

Hi, Looking for a person to create an spread sheet monthly for sales records during that month. Will need to take information off of individual sales order sheets/emails and transfer it onto a spread sheet... buyer/address/item(s) they bought/amount they paid etc. Will be a reoccurring task per month. Will pay per month, expecting 100-200 sales per month. Please show rate per entry.

I need a reliable professional to help me with monthly inventory updates from the dealers and the sales department. Key Tasks: - Quantity Update: Ensure all stock levels are accurately reflected in our records. - Product Description Update: Make sure all product descriptions are up-to-date and accurate. - Product Code, UOM (Kit/Vials), Rupee Value: Cross-check and update product codes, Unit of Measure (Kit/Vials) and Rupee Value accordingly. Format: I have a specific format that the inventory updates need to be in. You will need to use this template to ensure data consistency and compatibility with our existing systems. Frequency: This is a monthly task and I would need your support on an ongoing basis. Ideal Skills: - Proficiency in inventory management. - Attent...

I need an electronic signature created from a JPG as soon as possible. This signature will be used for signing documents, email communications, and physical printouts. can pay 15 CAD

I am seeking a skilled developer to create a comprehensive multi-vendor e-marketplace. It should allow users to upload items for sale or auction - a feature thoughtfully designed like a chat system to facilitate communication before purchases is a must. It should also allow the ability for users to be ranked and achieve different tiers for purchases completed and track volume / dollar value of total transactions to date. Key Requirements: - Design: The interface should be clean and minimalistic, delivering a user experience that is simple yet effective. - Categories: The e-marketplace will need to cater to "Clothing and Accessories". - Seller Profiles: Profiles should be feature-rich, including options for ratings and reviews, order history, and displayin...

I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the vehicle. - Est...

We are looking for freelancers who could help us with a 4 week pilot in one of the grocery stores in Cincinnati area. You would be responsible for capturing data in the store with use of our iOS app. - This task will require visiting the same store on multiple days or even everyday in case you're available for 4 consecutive weeks. - work: 2-8h per day depending on your availability - Pilot start day: likely June 23rd. Before this date you would need to install the app, read the guidelines and visit the store for a few times for some app testing. - Most of the store visits would need to happen at 9AM More info to be provided in the private message Requirement: iPhone 11 or higher Store address: to be provided in a private message

I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.

I'm looking for an experienced video editor who can take my raw footage and turn it into a polished, professional commercial video. I know for many of you might not be the winner. It's just the nature of the contest. I suggest not to waste your time and effort, if you are not very good or don't have much experience, or don't have good taste. For you, who would like to try, GOOD LUCK! I appreciate all your effort. I will make sure leave you a great review for you who win. What we need: 30 - 35 second video We are going to use the video for Youtube, FB & Instagram ads. Need the video in these formats: 16:9 , 1:1 & 9:16 More details of the project: Requirements: - Advanced editing skills,

...front-end with the back-end API endpoints to enable seamless communication and data exchange. - Optimize the web interface for performance, ensuring fast loading times and smooth user interactions. - Implement user authentication and authorization mechanisms to ensure secure access to the application. - Conduct thorough testing and debugging to identify and fix any front-end issues or bugs. - Stay up-to-date with the latest front-end development trends, techniques, and best practices, and incorporate them into the project when appropriate. - Collaborate with UX/UI designers to create visually appealing and user-friendly interfaces. - Participate in code reviews and provide constructive feedback to maintain high code quality standards. - Document front-end components, libraries, a...

I'm in need of a professional who has extensive experience with SharePoint, Power Apps, Power Automate, and secondary Power BI . I need support for my consultant indian time 8:30 pm to 11:30 pm Monday to Friday. 12$/hourly.. payment every saturday vai peayplea. I already have other indian guys who are working with me since 2019 to present. This support will be on zoom meeting. Which we will provide u and u will connect with my consultant for support.

I am looking for a capable freelancer to develop a chemical reaction generation model. The goal is to do retrosynthesis, so basically predicting reactants from every SMILES product on my test data. You can use whatever you want(pre trained models or you own script)

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

It is necessary finish a web application in python + django regard the statistic of stocks. So it is necessary: some fetaures of some filter; -. make some change to mysql database and api to datafeed. -. verify the formulas and add some features; -. make better the design. - create an admin page with security login and import stocks manually. Please answer only if you can show similar experiences

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

I need a creative edge to breathe new life into my clothing brand. I'm searching for a talented...adults. Key requirements of the role: - Designing casual wear: This project focuses solely on adult clothing, so experience with contemporary and casual design is essential. - Innovation in fashion: I'm after someone who is not afraid of pushing the boundaries and trying something new. - Knowledge of current trends: Awareness of ongoing fashion trends for adults is important to ensure our brand remains relevant and appealing. - Demonstrable experience: Please provide examples of your previous work, particularly with casual wear design for adults. Your unique touch could be the one to define the future of my brand. Apply today if you have the skil...

I am looking for a skilled digital marketer, specifically proficeint in utilising Facebook and Instagram to increase brand awareness and generate leads for my project. The successful freelancer should have a solid understanding of strategies to engage an audience aged between 18 and 24. Your expertise will help drive a successful digital marketing campaign. Key skills required: - Facebook and Instagram marketing - Generation of leads - Increasing brand awareness - Targeting the 5-12 age demographic

I have website backup which needs to be restore and fix its pages to be in working condition. there are 6-8 pages in total and its simple website. Fixed Budget: 10$

I'm looking to have a new website created. The key task involved in this is harvesting photos and data from Website A, and using this to create our site. The following details outline the project requirements: - Downloading photos and data from Website A. - Upload these photos and data to the corresponding sections on our website. The new site should mirror the content placement of Website A. Ideal skills for this job include website creation, data extraction, and efficient data input methods. Experience with content migration is highly desirable. Deadline for completion is within a month from the project start date. All data need to be updated each day

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn...

I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the nature ...

We need people, as many as possible from the UK and AU to shoot a UGC video on how our product cleans your teeth. Here is an example: Here is our website: **Who we need based on our target audience:** - Female and Male between 35-44, (Mostly Female) - Mostly have a family and childrens or family oriented - Possibly a smoker or regular coffee drinker. **What we need:** - Make a Video about using our product for a few days using our scripts, you can come up with your own but basically we will provide everything. **From us:** - 50-70$ for a ready edited video 60 seconds long. (we can do the editing ourselves) - Our product you will keep and you can

...depending on experience) / month Contract: Full time - 40 hrs. / week (flexible schedule with at least 3 hrs. overlap with US Pacific business hours) Position Overview: The Sourcing and Procurement Specialist will play a pivotal role in our operations, responsible for managing client accounts and sourcing materials from various platforms and suppliers. The ideal candidate will be fluent in English and have strong Mandarin skills, as a significant portion of our supplier base is located in China. They will have a strong background in mechanical engineering, sourcing, negotiating contracts, and coordinating logistics. Strong communication skills will be essential to effectively communicate client needs to suppliers and manage the end-to-end procurement process. Qualificati...

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issues - Strong un...

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

...an experienced and skillful data analyst or statistician who can help me present a detailed paper explaining data analysis techniques, with a special emphasis on Multivariate Test Effect Pillai's and Descriptive Statistics. what I need in this project is to explain for me how and why the calculation is done in this way in the paper that I will provide you later on so the statistic analysis is already done. I only need the explanation for my own understanding. So is there any possible way that we can conduct this explanation exercise today The target audience for this paper are academics and researchers, therefore, the tone and depth of the content should accommodate this group effectively. The ideal freelancer should have: - A strong backgro...

I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis...

...Overview We are creating an upbeat and engaging promotional video for Cookie Brand to be used in Facebook advertising. The goal is to showcase our wide range of cookie flavours, highlight the quality and freshness of our products, and entice viewers to visit our website and make a purchase. The video should reflect the fun, cheeky, and funky personality of our brand, utilizing still images creatively. Target Audience Women aged 25-54 Cookie lovers and those looking for delicious, premium treats Key Sales Points Over 30 funky cookie flavours Made with premium ingredients Rave reviews from satisfied customers Freshly baked to order Video Specifications Length: 30 seconds Tone: Upbeat, fun, and playful Music: Energetic and cheerful Visual Style: Bright, color...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world setting...

More details: What specific goals do you have for your Italian cafe's online presence? Looking for marketing expert What information should successful freelancers include in their application? Detailed project proposals How soon do you need your project completed? ASAP

...job card system that will allow the creation and editing of digital job cards. There is also a requirement for quotes, parts / inventory, archived jobs, and customer management. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to export completed jobs to CSV file for automated invoice generation in Quickbooks Online. We will also require the system to import the customer database from Quickbooks in CSV format. Key Functionalities: - Creation and Editing of Jobs - Ability to use system on-site / remotely through the use of iOS or Android web browsing. Some - Ability to select a simple job status from a drop-down combo box eg. In-progress, waiting for collecti...

I need to have a girl removed from a short, high-definition video of myself and my sister. The video is less than a minute long. The girl to be cropped out is positioned in the middle of the video and I want the edited outcome to feature just my sister and I. Key tasks include: - Identify and crop out the girl from the video - Ensure smooth transition and maintain overall video quality - Final video should be in high-definition Skills and experience necessary: - Proficiency in video editing software (Adobe Premiere Pro, Final Cut Pro...) - Ability to crop out individuals effectively and smoothly - Experience with transitional effects may be necessary - Attention to detail and creativity.

Develop macro-enabled Excel file to handle CSV

...patterns and the logo. The banners should have a minimalistic design and include the destination name in both English and Arabic. Key Requirements: - 10 Instagram banners for holiday packages - Minimalistic design approach - Destination name in English and Arabic - Brand logo placement - Brand patterns integration - Text "Book Now" Please note the following: - I have a specific deadline of 2 days for this project - I can provide you with all our branding materials, including guidelines, patterns, and logos - The destinations for the holiday packages are predetermined and should be featured in the banners Ideal Skills: - Proficient in Adobe Creative Suite, particularly Photoshop and Illustrator - Experience in creating engaging and effective social media graphics - U...

...document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout integrity. - Attention to detail: Given the complexity of th...

Here is the text formatted as bullet points: - I am looking for a freelancer specializing in motion graphics design to create a marketing video for a legal company on TikTok. - The video should not exceed 30 seconds in duration. - The video should be in Arabic only. - The style should be cartoonish and include the following elements: - Icons - Characters - Text - The target audience is young people between the ages of 18 and 30. - The video must contain sound effects only, without music. - It should also include a voiceover in Arabic (AI-generated voices can be used). - and use this files - Please provide some examples of your previous work - The delivery time is only two days only .

Please Sign Up or Login to see details.

...that the extracted table is ready for analysis. Please note that no additional data preprocessing is required. (feel free to rewrite code if you have better idea) --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in chinese, so must use chinese to view it. table name/string partially e.g. "現金流量表" or "被投資公司名稱" or "資金貸與他人"or "轉投資大陸地區" or other name(later can be change). extract table based on table names/string. the table ma...

I need a profess...The aim of this presentation is to effectively represent: - Our company's business and main history milestone - Our mission and core values - Our company's business performance data - Our future business strategies A broad understanding of business analytics is essential as business performance data will be central to the presentation. Expertise in chart and graphics creations within Google Slides would be useful—it's important that the data is easy to digest and visually appealing. A creative outlook would also be beneficial to deliver our strategies in an engaging way and to help articulate our company values. Previous experience in business strategy presentations would be perfect. We will provide all the contents and the dat...

...helping businesses thrive in the digital landscape. Our team is passionate about crafting creative strategies and delivering measurable results for our clients. *Role Overview:* As a Lead Generation Expert, you will play a crucial role in identifying and engaging potential clients interested in our social media marketing services and closing deals with them. You will utilize various research and outreach techniques to identify leads, initiate conversations, setup sales call, and nurture relationships with prospects. *Key Responsibilities:* 1. Research and identify potential clients through online platforms, industry directories, and social media channels. 2. Develop and maintain a database of leads, ensuring accurate and up-to-date information. 3. Craft personalized ou...

I need someone that is really good at finding market data & analyzing it. I am having an event and we are trying to get paid sponsorship.
 Currently we are working on the pitch decks to send to companies requesting sponsorships.

 I need to find some market data to include within the pitch deck to convince sponsors that my demographic is important & using us will help their business.



 1st Task - Find market data
 2nd Task - From the data, think of an argument or convincing reasons for the sponsor to fulfill our requests. How will it be beneficial to them? The event is for United States black professionals in the entertainment industry. 
 Your job is to find some market data for:
 Black Professionals Black Entertainment Professionals Sociali...

I'm looking for a motion graphics designer to create a series of 15-30 second movies, with a total of five films. The main goal of these movies is to educate a health-conscious audience about the benefits of a Low Carb diet. We have five scripts for you. Look in the bottom of this post to see how the scripts looks. Key Requirements: - Crafting engaging and informative 15-30 second motion graphic videos - Using provided scripts to create the movies - Targeting health-conscious individuals as primary audience The selected freelancer should have: - Demonstrable experience in creating educational motion graphic content - A portfolio showcasing previous work in the field - Understanding of the principles of designing for specific audiences, especially health-conscio...

I have a photo where I would like to remove a person who is on the side. (Want to keep only the girl in the black shirt) remove the other one on the left of her Key requirements: - Remove the person on the side of the photo while keeping the background intact. The background is mixed, with some areas more complex than others. It's essential that the background maintains its original look, even after the person is removed. - The final use of the edited photo will be for personal use, so the editing needs to be of a high quality. Ideal freelancer: - Previous experience in photo editing, specifically in object removal while maintaining the background. - Proficiency in tools like Photoshop or similar software. - Attention to detail and ability to de...

...identifying profitable product opportunities on these e-commerce platforms. Your main duties will include performing competitive analysis, conducting keyword research, and staying up to date with industry trends. The ideal candidate should have a strong understanding of AMZ, eBay, and Walmart's search algorithms, excellent analytical skills, and the ability to generate actionable insights. Required skills: - Proficiency in AMZ, eBay, and Walmart research tools - Experience in competitive analysis and keyword research - Strong analytical and problem-solving abilities - Knowledge of product trends and consumer behavior This is a medium-sized project with a duration of 1 to 3 months. We are looking for an intermediate-level researcher who can deliver accurate and compr...

I'm seeking a fluent Japanese writer or Japanese press release agency capable of crafting engaging press releases about company news in the fashion retail sector. Although primarily focused on Japanese language texts, having bilingual skills is a bonus. Key Responsibilities: - Keep up-to-date with our company's latest news - Craft compelling press releases in Japanese to draw attention to our updates Ideal Skills and Experience: - Proven experience in corporate news writing - Familiarity with the fashion retail industry - Fluent in Japanese; bilingual abilities in English and Japanese preferred - Strong skills in adjusting writing style to fit brand voice.

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

...similar to quartzluxurywindows.com. AND a 10 pages Product Brochure/booklet from a sample hardcopy Key Features: - Product Catalog: The main functionality of the website will be to display the range of windows that we offer. The windows should be categorized by product type, similar to the organization on quartzluxurywindows.com. Requirements: - Experience in developing custom websites, particularly product catalogs. - Strong understanding of web design with an emphasis on user experience. - Ability to replicate the design and functionality of an existing website (). - Familiarity with organizing products by category. Optional: - Knowledge of SEO best practices to ensure the website is search engine friendly. - Experience with integrating online quote forms or other