Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Efficient Method to Calculate Future Month in Excel

·

·

What's the most efficient way to create a column that just says the month two months from now? So right now it would read "February"

Efficient Method to Calculate Future Month in Excel | Clay

5 comments

· Sorted by Oldest

Channeled
APP
·
·
Here's how to create a column with the month name you need: 1. Click "Add Column" > "Add Column using AI" 2. Once in the date formatter: • Input your date (you can use a formula to get current date + 2 months) • Select your desired format for displaying the month name • Optionally, you can specify: • Timezone settings • Locale (if you want the month name in a different language)The formatter will automatically update the date/time values for new rows in your table. Sources: Clay Formatters Overview - Clay University Add Column Using AI & Add New Rows Format Date/Time with Clay Formatters
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Bruno (Clay)
·
·
Hi Julien, thanks for reaching out. Taking a look at this now!
Bruno (Clay)
·
·
You can use this javascript formula: moment().add(2, 'months').format('YYYY-MM-DD') - which will allow you to add a set amount of month to your current date, you can edit the number to increase or decrease the number of months you want to offset the column from today's date.
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.