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

This is for the new profile view update and you will not be able to view it until the update finalizes and makes this the new normal profile view.

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

...and creative professional who can help me in editing my PowerPoint presentations and a video that I've compiled. The aim is to give them an up-to-date, corporate and professional look for the purpose of our website launch. Key Points: - For the PowerPoint presentations, I need someone who can help in redesigning slides. This involves the use of infographics and new age graphics to make the information visually appealing and easier to understand. There's a need to reduce text in the PPTs and replace it with infographics. Also, enhancing visuals would be a great addition. - There's also a need to edit the content for a professional tone. This means ensuring that all text is well-written and suitable for a corporate environment. - The overall theme for ...

...engaging animated videos. The main goal of these videos is to educate the audience on a variety of topics, such as Science, History, and Health and wellness. Sample reference video. Key Responsibilities: - Create visually engaging and informative animated videos - Ensure the content is clear and easy to understand for the intended audience - Develop storyboards and scripts in coordination with me Ideal Skills and Experience: - Proven experience in creating educational animated videos - Strong understanding of the topics mentioned, Science, History, and Health and wellness - Excellent communication skills to work closely with me on content creation - Ability to create content that is both engaging and educational Please share samples of your

...expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, interactive visual reports - Strong understanding of data analysis and visualizati...

...This is a crucial aspect of the design. It needs to be easily accessible and comprehensible to users. - Price charts and graphs: These should be clear, visually appealing, and easy to interpret. Style: - Modern: I envision the UI with a modern feel, so it appears up-to-date and in tune with current design trends. The ideal candidate for this job should have: - Proficiency in Figma: As this project involves Figma design, it's important that the designer is comfortable and skilled in working with this software. - Experience in crypto projects: Although it's not mandatory, having previous experience in designing for crypto projects will be a big plus. - A keen eye for detail: Since the design needs to be both visually striking and user-friendly, a meti...

...total sales, check v3. - shop field (brand name, address, website, whtasapp, facebook, description, category, City, how many brands, open for agency?(radio button)) - promotion field (title, normal price, now selling price, description, expire date, point weight - V4 user can follow shop to see their promotion in feed, also can apply to be their agent. - agent can share the promotion with uniqic referral link which will earn 2% v3 - point system- user purpose any thing will get point same as the price, usd 23.12, will get 23.12 points. if point weight is 2, then he will get 46.24 point. - when userB purchase, user A will get 1% profit earning - when ANYONE share promotion, User b saw it and buy it, upline userA will get 1% profit and ANYONE show share will get 2%...

Rebuilding a fullscreen section in Elementor on your server Content Homepage / Fullscreen Section: Animated font Animated flipping image menu Please only report freelancers who can realize this today. It is not a very big task Thank you

Who we are Lezzat is an Amazon marketing agency based in Reading, UK and Athens, Greece. We are bunch of Amazon sellers ourselves that got frustrated with the process of selling on Amazon, decided to provide our services so others will not face the same problems. Our team constitutes of marketing specialists, designers, photographers & consultants that are here to alleviate the complexities of selling on Amazon. Some of the world’s most popular consumer brands and innovative start-ups are our clients. About the role We are looking for a focused, driven Amazon Account Manager. The ideal candidate stays on top of Amazon’s marketing trends, has experience with Amazon listings (including flat file expertise), product research and Amazon software tools. You will be requi...

I am in need of a skilled frontend developer to build the interface for my customizable meal delivery website. The website is designed to cater to users who would like to customize their meal plans as they order. Key Functionalities: - Real-time order tracking: I'd like the website to have a feature that allows users to track their orders in real time. This feature is essential for providing a great user experience, ensuring customers are up to date on their orders and can anticipate delivery times. Skills and Experience: - Proficiency in frontend development: You should have prior experience in developing user-friendly and visually appealing websites. - Familiarity with real-time tracking systems: Experience with implementing real-time tracking features on webs...

I need a professional content creator skilled in human development to provide me with 30 video scripts and ideas for my business centered on getting rid of old block how nervous system control you, personal growth, overcoming fears, and building self-confidence. Each script should be educational and informative, while maintaining a concise length of 1-3 minutes. Key Requirements: - A solid understanding of human development, personal growth, and related topics - Proven experience in creating concise and engaging video scripts - Ability to convey complex information in an easy-to-understand manner - Strong writing skills with a focus on educational content - Previous experience with similar projects is highly preferred Your work will play a crucial role in helping individua...

I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.

I need financial data from bloomberg or any other database for research.

I'm seeking an expert in Excel analytics. This project involves working with existing but undisclosed business data to help me understand and optimize the business's performance through indicators like KPIs. The freelancer's task encompasses: - The creation of robust dashboards that effectively communicate KPI outcomes. - The execution of classification analysis to differentiate key data points. - Clustering the data into discernable patterns to aid business decision making. Ideal skills for this job include Excel proficiency, data analytics experience, and an understanding of key business metrics such as KPIs, dashboards, classification, and clustering. A background in business data analysis and the ability to assign meaning to raw data is desired.

Hello Christian, Thank you for discussing the interior design project for your living room. Considering the floor plans, photos, and moldboard design you've shared, I propose delivering approximately 8 realistic rendering images within 7-10 days for 700 EUR. The payment will be divided into two milestones: one for the preview and another for the final rendering images. Best regards, Mohsen

I'm in the process of designing an e-commerce website in Figma and I'm seeking a frontend developer who can transform this design into a fully functional and responsive website. Key Functionalities: - Shopping Cart: A seamless and user-friendly shopping cart integration is crucial for this project. The cart should allow for addition of items, editing of quantities, and a smooth checkout experience. - User Registration and Login: The website should have a user registration and login system. This will help in personalizing user experiences, managing orders, and providing security to customers. - Product Search and Filter: A crucial feature for an e-commerce site. It should enable customers to easily find products they are interested in, through categories, filters, and sear...

I'm seeking an experienced 3D designer to create a model for a walking training dog harness. This needs to accommodate medium (30-60 lbs) and large (60+ lbs) dogs. Essential features are a front and back-leash attachment. The front leash attachment will be like a choke chain collar attachment (see attached). Fluent expertise in 3D modelling software is paramount. Previous design experience in pet accessories would be advantageous. I will also require manufacturing designs. Expectations include: - Designing a multi-feature training harness - Ensuring durability for mid-large dogs - Prioritizing comfort and control in design - Incorporating both a front and back leash attachment - Showing the dinosaur skull head in white with black background. - breathable fully adjustab...

I'm in urgent need of an experienced web developer to create a simple interactive website. The site should be designed in a modern and simple st...tell you what colours). The main features of the website should include a login/sign-up, and user profile functionality and a unique feature which is the map (I have the link for it) Key Expectations: - Create a modern, interactive website - Use HTML, CSS, and JavaScript with any UI framework or JS library of your choice - Implement a simple login/sign-up, and user profile page -Embed a map (i will provide you the link) I have attached my wireframes of how the basic website should look like. I am looking for a developer who can deliver this project as quickly as possible (2 days max). Please let me know if you'...

I'm in need of a professional who is highly skilled in Excel for a project involving 4-color conditional formatting. The project will focus predominantly on numerical data. Here are the essentials: - Proficiency in Excel is crucial - Deep understanding of 4 color conditional formatting, specifically with numerical data - Experience with setting color-coding based on specific values I'm looking for an expert who can swiftly and accurately apply this formatting to a substantial amount of data. Thanks for considering bidding on this project.

I have a joyous announcement to make and need the creativity of an experienced graphic designer. ...creativity of an experienced graphic designer. The design must revolve around baby-themed illustrations and should encompass a pastel color scheme to add to the cheerful atmosphere. The main specifics the design should feature include: * Baby-themed illustrations that are appealing yet subtle. * A suitable and captivating arrangement of pastel colors. Moreover, this announcement must feature the due date of the arrival of my new bundle of joy. An eye for detail and a knack for creative communication are must-have skills. Experience in designing baby announcements or similar projects will be highly preferred. Bring on your creativity and make this momentous period all the more speci...

...System (MIS) for my supply chain operations. Critical features should include: - Order Tracking: The system should provide up-to-date information on order status and delivery dates. - Supplier Management: The software should keep track of supplier-related data including payment information. For the inventory management component, the following capabilities are imperative: - Real-Time Tracking: The system should provide instantaneous updates for inventory data. - Low Stock Alerts: The ability for the system to alert when inventory runs low is crucial. - Sales Forecasting: Incorporation of a sales forecasting tool based on inventory output and sales history is an added advantage. Experience in supply chain management software development and understanding of i...

I am seeking a freelancer with experience in data entry to assist me with my project. The ideal candidate will be proficient in entering textual data from online sources. Scope of Work: - Enter textual data from online sources - Ensure accuracy of data entry - Complete the project within 3 days Skills and Experience: - Proficient in data entry - Experience in working with online sources - Attention to detail and accuracy - Ability to work efficiently within tight deadlines

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

...GOOGLE DOCK BELOW CAREFULLY AND CONTACT US FIRST IF YOU HAVE QUESTIONS* Details of our current project STACK can be seen here -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immedi...

...offerings and pricing structures. The goal is to provide a comprehensive, visually appealing summary that highlights key features, subscription plans, and costs associated with each software. Scope: Competitors: The platforms to be analyzed include Saninet 3D Planner, MATICAD DOMUS3D, PALETTE CAD, TILE LOOK, VISOFT, and SPARK VISION. Data Collection: Extract detailed information from the competitors' websites, focusing on: Price Features Customer Support Compatibility Cost Type of Subscription What is included in each type of subscription 3D Modeling Costs: Gather information about the costs associated with 3D modeling for new products, including the data required for the modeling process. Requirements: Pricing Comparison: Compile accurate, up-to-date...

Need SEO professional to assist me with backlink building and guest post services. Must* Key Requirements: - (1) Domain Authority (DA) 30+ - (2) Backlink Website Traffic: 3000 - (3) Relevance: Sleep, Wellness, Health Please send 5 backlink URL and price for each

As we venture into the development of an online store for both Instagram and Facebook, we are looking to showcase our unique product - gift paper bags and gift packing wrappers. Key tasks include: 1. Developing an online shop for two social media platforms. 2. Creating engaging, sellable de...include: 1. Developing an online shop for two social media platforms. 2. Creating engaging, sellable designs for our products. The ideal professional for this work should not only have experience in social media store development but should also be a credible product designer. They should understand up-to-date trends and be able to make design suggestions that will appeal to our consumers. Creativity, with a keen attention to details, and experience in design related to gift packaging is...

I have a bulk of digital files that need to be accurately transcribed into a digital format. The files are all in English, so proficiency in English is necessary for this project. Ideal skills and experience include: - Proficient in English - Fast and accurate typing skills - Experience with data entry

...Creating a 12-month marketing calendar; * Collaborating with the website development team and internal IT and marketing teams; * Ensuring the project is completed within the agreed timeline and budget. Proposal Working remotely with on-site presence for the initial project kick-start 16th to the 27th of May 2024 and with on-site presence half way or towards the end of the project (dates to be discussed). Fee is $25,000 per month. Initial period projected to be 3 calendar months from the 16th of May 2024 to the 16th of August 2024. If my services are required after the estimated completion date of the 15th of August then the monthly remote fee is $25,000 per month. Payment schedule First payment - 17/05/24 - HKD $20,000 (USD $2,562) Second pa...

I'm in urgent need of an urban planner to assist me with a project related to the program 'Building Cities'. I need now help in the first part which is CITY FOUNDING i dont seem to relate between the CITY PLANINGm the CITY FOUNDING which is building the city hall and the Geography regions like the attached WOODLAND It should be simple.... check it out ... its urgent for today

I find myself in need of a skilled freelancer to restore my suspended Google Business account. My account was suspended due to exceeding the storage limit, and I have been unable to fix this issue myself. The professional perfect for this job should excel in: - Google Business account restoration - Dealing with suspension issues, specifically exceeding storage limit - Providing tips and guidelines on how to avoid future suspensions due to storage issues The task includes confirming the suspension reason, working towards resolving it, and ensuring resumption of the account. Knowledge on dealing with Google's support system would be highly advantageous. Looking forward to working with you.

I need a proficient Microsoft Word expert to design a comprehensive report template that contains all the requisite sections for a detailed report. The ideal freelancer for ...understanding of Microsoft Word. - Previous experience in creating professional templates or reports. The key sections that the report template should include are: - Title page - Table of contents - Introduction - Body - Conclusion - References Each section should be clearly defined and easy to navigate. For the title page, it should encompass the following elements: - Project title - Client's name - Date - Project logo - Project description - Title block I require standard formatting and styling for the title page and the entire document. It's crucial that the template looks professional, clea...

I need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.

I am in need of someone who can promote and edit videos for my residential real estate Project I have some clips and a reference video Also I need someone who can help me with describing the popular location surronding my site using "google earth" which i have a reference Project needs to be completed within today If anyone available Kindly BID

...registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The successful candidate should have experience in creating user registration modules. - Excel upload integr...

...including LinkedIn, Online courses, website and Only Fans (If you are not comfortable with male nudity or medical procedures, this is not for you) We have multiple businesses and multiple channels: - One is a day spa - One is an injectables clinic - One is a penis Enlargement Medical Clinic - We will provide: Footage - Broken down in Dropbox folders Guidelines - As per Australian medical guidelines Ideas - List of ongoing topic ideas - Video Editing Needs: I require advanced video editing services, focusing on tasks like color correction and incorporating some special effects. Slight background music and some subtitles. - Timeline: The work will be ongoing and required on a weekly basis. - Weekly output example: 5 x reels, a 30 min course...

Project Scope * Overseeing the development of a new website for the Client; * Launching an e-commerce store within the new web...Creating a 12-month marketing calendar; * Collaborating with the website development team and internal IT and marketing teams; * Ensuring the project is completed within the agreed timeline and budget. Proposal Working remotely with on-site presence for the initial project kick-start 16th to the 27th of May 2024 and with on-site presence half way or towards the end of the project (dates to be discussed). Fee is $25,000 per month. Initial period projected to be 3 calendar months from the 16th of May 2024 to the 16th of August 2024. If my services are required after the estimated completion date of the 15th of August then the mo...

...goal of the app will be daily reporting. This means users will be able to easily submit reports on a daily basis. - The app should be intuitive, user-friendly and well-designed. - Security is also a key consideration, as the reports will likely contain sensitive information and should be well-protected. - Please provide examples of similar cross-platform apps that you have developed. - Experience with reporting functionalities and/or data security is a plus. Features of the Application will be, Name and class of app is daily Class reporting Software 2. Select the class you taught today from class 3 to class 12 3. Select the topic 4. Upload videos, and queries. 5. Mark it as done partly done or not done 6. Integrate it with calendar 7. Mark holid...

I'm looking for an experienced Linux professional with a knack for data analysis to assist me with my projects. Ideally, you will possess: - In-depth knowledge and understanding of Linux as you will advise ...numerical data. - Proficiency in data sorting, statistical analysis, and data visualization techniques as these will be a fundamental part of the job. In addition, knowing how to decode SecretKeys with the bs58 library is a crucial aspect of this project. This task represents a core operation you will be required to perform with the numerical data. Your ability to execute this function deftly will significantly impact the project's success. I am looking to begin the assignment as soon as I find the right fit, so please ensure your bid reflects your best offer and ...

...goal here is to increase sales but also build brand awareness and drive traffic to my shop on Etsy -- I currently use Facebook, Instagram, and Pinterest for promotion, but I'm open to exploring other platforms if you have suggestions - My target audience is women all over the world but especially UK,USA and rest of the Europe Ideal skills and experience for this job include: - Proven experience in social media marketing, particularly in the e-commerce space - Strong understanding of the Etsy platform and its audience - Ability to create engaging content that resonates with a female audience - Track record of achieving tangible results in terms of sales, brand awareness, and traffic growth through social media marketing - Up-to-date knowledge of social m...

...########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking Order Payment Order Deliverables Order *Quiz ---------- Select service select size Select colours Select additional information Comments Attachments Submit Two way chat (communication) Your Profile Notification settings Payment Settings ############################################################# Designer Dashboard ------------------ Kanban Board ################################# If you are software developer and love to work on such projects, please feel free to contact us about the project. Please include your previous work, cost and duration fo...

I'm looking for a skilled animator to create an old style pencil animation gif for my upcoming wedding event. Key Requirements: - The animation should be in an old style pencil animation format. - The animation should be long, over 20 seconds. - It should include the couple's names, the wedding date and the wedding venue. Ideal Skills and Experience: - Proven track record of creating animated gifs, especially in the pencil animation style. - Proficiency with relevant software and tools to create and edit such animations. - Attention to detail, as the animation needs to include specific information about the event.

I am looking for a freelancer who can help me automate my web search for bid opportunities (RFPs) for my telecom company. Currently, I rely on searching manually, but this process is time-consuming and not as efficient as I'd like. Key Project Requirements: - You will be responsible for setting up an automated search that looks for RFPs related to "fiber optic" or other telecom-specific keywords, which are due every May 2024 or similar queries. - This automated search needs to run every 2-3 weeks, ensuring that I stay up-to-date with new bid opportunities and future due dates. - You should have a deep understanding of web scraping and automation to accomplish this task. Additional Information: - I would like to receive notifications about new bid opportun...

...professional to provide 2600 Flash in a widely accepted cryptocurrency like BTC, ETH, or USDT for a Private Placement Program. This coin is only required to sit in a wallet for 30 - 60 days. It will not be cashed, traded, or exchanged. Key Responsibilities: - Providing 2600 Flash in a widely accepted cryptocurrency - Transferring the coins into a secure wallet and ensuring they remain untouched for 30 - 60 days Ideal Skills and Experience: - Familiarity with cryptocurrency trading - Experience in Private Placement Programs and related procedures - Trustworthiness and reliability - Strong understanding of digital wallets and their security protocols This is a straightforward task that requires someone who can deliver on time and maintain the ...

I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.

I want to design a car wash, and I want to import the goods from China, but I do not know what is the method, the best quality, and the method of communication. I want boxes for electric tanks that are made of carbon fiber, I want washing materials, I want water pumps, vacuum cleaners, all cleaning tools, and some other things. Ideal Skills: - Proficiency in Chinese - Experience with online dispute resolution - Strong communication skills - Understanding of international commerce and refund procedures

We are looking for a highly skilled development team to recreate a complex web platform in JavaScript. This is expected to be a three to six month project, requiring a minimum of six full time developers. This platform will reside on the AWS network, preferably using MySql and Linux. We will be recreating a PHP/MySQL platform to a JavaScript/MySQL platform with approximately 200 features. This new platform will require a significant upgraded user experience, integration of animated graphics and faster reports processing. Our current platform has some components that are 10 to 20 years old. You will be creating from scratch and not using ANY of the current code. Key Developer Requirements: - Extensive experience in JavaScript platform development. - Access to skilled User E...

I'm seeking a talented video creator who specializes in crafting tutorial videos. ...breaking down complex legal concepts into understandable lessons for viewers. Each video should ideally span a length of 30 minutes, with attention paid to maintaining viewer engagement throughout. Key Responsibilities: - Create high-quality tutorial videos on legal topics - Ensure the video length is around 30 minutes - Break down complex legal subject matter into digestible content Ideal Skills and Experience: - Proven experience in video creation, particularly tutorials - Knowledge or interest in legal subject matter - Ability to engage viewers for extended periods Please provide examples of previous tutorial videos you've created, especially ...

I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeVal...