Excel date, page 2 - Ablebits.com Blog

Svetlana Cheusheva

Jun

17

How to conditionally format dates and time in Excel - built-in rules and formulas

See how to apply Excel conditional formatting to dates. Learn how to use formulas to highlight weekends and holidays, format cells when a value is changed to a date, shade upcoming dates and delays, conditionally format dates based on the current date, and more. Continue reading →

by Svetlana Cheusheva | updated on October 9, 2020 726 Comments

Pages: 1 2

Home
Products
Windows
Ultimate Suite for Excel Add-ins Collection for Outlook Shared Email Templates for Outlook
Mac Os
Text Toolkit for Excel Shared Email Templates for Outlook
Outlook Online
Shared Email Templates for Outlook
Google Workspace
Add-ons for Google Sheets Add-ons for Google Docs
Ultimate Suite
60+ professional tools for Microsoft Excel

This comprehensive set of time-saving tools covers over 300 use cases to help you accomplish any task impeccably without errors or delays.

Merge multiple worksheets

Compare sheets for differences

Remove duplicates

Merge cells in Excel

Calculate dates and times

Combine sheets by column headers
Trim extra spaces
Count characters and words
Convert text to number
See all tools

Works for: Windows
Read more about Ultimate Suite
Add-ins Collection for Outlook
8 essential tools to streamline your email workflow

Best add-ins for Microsoft Outlook in one collection to reveal the full power of your inbox and improve your emailing routine:

Reply to email with template

BCC/CC automatically

View conversation's attachments

Check e-mail before sending

Unhide and analyze email headers

Be alerted for important messages

View email sender's time-zone

Reply to email in a couple of clicks

Works for: Windows
Read more about Add-ins Collection
Shared Email Templates
Custom email templates for teams and individuals

Do not waste your time on typing the same replies to repetitive emails. Compose your response just once, save it as a template and reuse whenever you want.

Quickly reply to emails with templates

Personalize your replies with macros

Attach files and images automatically

Use Outlook drafts as templates

Create beautiful email designs

Protect your privacy with encryption

Use on touch-enabled devices

Run on PC, Mac, Windows tablet

Works for: Windows•macOS•Outlook Online
Read more about Shared Email Templates
Text Toolkit for Excel
35+ handy options to make your text cells perfect

Instead of building formulas or performing intricate multi-step operations, start the add-in and have any text manipulation accomplished with a mouse click.

Trim extra spaces

Convert text to numbers

Count characters and words

Change letter case

Extract text or numbers

Remove text by its position

Add the same text to selected cells

Split cells by symbol, string, or mask

Replace unwanted characters

Eliminate leading zeros

Clean non-printing characters

Swap text in your cells

Works for: macOS•Excel Online
Read more about Text Toolkit
30+ tools to boost your Google Sheets
This smart package will ease many routine operations and solve complex tedious tasks in your spreadsheets.
Read More Try it for free

Add-ons for Google Sheets

Merge Sheets Function by Color Remove Duplicates Combine Duplicate Rows Combine Sheets Consolidate Sheets Split Sheet See all products

Add-ons for Google Docs

Search & Navigate Doc Tools Styles for Google Docs
Download
- Actual versions
- Archived versions
Docs
Support
Blog
About us
Purchase

60+ professional tools for Excel

60+ professional tools for Excel
2019–2007 to do your daily work

Incredible product, even better tech support…AbleBits totally delivers!

Anyone who works with Excel is sure to find their work made easier

The best spent money on software I've ever spent!

Ablebits is a fantastic product - easy to use and so efficient.

Excel is at its best now

I don't know how to thank you enough for your Excel add-ins

Jennifer Morningstar

Anybody who experiences it, is bound to love it!

AbleBits suite has really helped me when I was in a crunch!

I have enjoyed every bit of it and time am using it

Christian Onyekachi Nwosu

It's the best $100 we've ever spent!

I love the program, and I can't imagine using Excel without it!

One word… WOW!

Love the products!

It is like having an expert at my shoulder helping me…

Linda Shakespeare

Your software really helps make my job easier

Thanks for a terrific product that is worth every single cent!

I love your product

Sheila Blanchard