Help
I have a formula adding 17 days from a date in another column.
It is adding the time. How do I eliminate the time?
ALSO, is there possible logic to add to move the date forward if it falls on a weekend?
Thank you for any help provided!
Question
Remove Time from Date Formula
+4
+35Click on the “formatting” tab in your screenshot above, and you can disable the time.
- ScottWorld, Expert Airtable Consultant
+35
You’re welcome! Oh, to answer your other question, you can completely skip over weekends by using this formula:
WORKDAY({Sales Winner Starts}, 17)This would skip over Saturdays and Sundays, and you can also add in an optional list of holiday dates, as explained on this page.
However, if you don’t want to skip over ALL weekends, and you just want to make sure that the final day lands on a workday, you would need to create a longer conditional formula for that.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.