Support
Help Center
Airtable Universe
Airtable Templates
Airtable Guides
Developer Documentation
Sign up for Airtable
Airtable Community
Announcements
Discussions
Ask A Question
Show & Tell
Development & APIs
Groups
Airtable AI
Airtable Enterprise Network
Marketing
Product Operations
EDUser Group
Events
Resources
Getting Started
Job Board
Product Ideas
Search
Community
Knowledge base
K_Williams
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Help
Sign In
Browse
Airtable Community
K_Williams - profile
K_Williams
5 - Automation Enthusiast
since
Mar 01, 2017
Nov 29, 2022
User Statistics
3
Posts
0
Solutions
0
Kudos given
1
Kudos received
User Activity
Posts
Replies
Use formula to find oldest date in row
Mar 01, 2017
Hi, I have a row with several expiration dates in different columns. I’d like a cell to calculate which of these dates in the row is next date to Expire. I’ve tried MIN() but it doesn’t recognise date values. Any suggestions? Thanks.
Re: Use formula to find oldest date in row
Mar 09, 2017
I’ve changed it a little and now calculating the months and using MIN so it is working now. Thanks for the response.
Re: Use formula to find oldest date in row
Mar 09, 2017
It’s not working. I can’t even get the cell to show if the date is < or > than today in a standard IF formula. I am using LOCAL date format.
Kudos from
User
Count
Hashim_Warren
1
View all