Hi All
In my rows there is not a date for me to pull from but I want my Zap to insert {Today’s Date} into my excel sheet - is there a formula or something I can write to get it to do that without pulling it from somewhere?
Best answer by SamB
View original
+6
Depending what you’re doing after the spreadsheet step, you might be able to accomplish this with the TODAY function in Excel.
Just use {{zap_meta_human_now}}
Here’s the article on using it: https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field
If you need only the date, try using a formatter step and transforming {{zap_meta_human_now}} to a format that suits you better.
+11
Hey all! I just wanted to pop in here to confirm that using =Today() in the date field would automatically add the current date into your Excel spreadsheet in M/D/YYYY format . For example:
Would appear in Excel as 3/9/2022:
And using {{zap_meta_human_now}} would add both the current date and time.
So it would appear in MM/DD/YY hh:mmA format:
If there’s a specific date format you’re after you could use a Formatter (Date / Time > Format) step to convert the date into the desired format:
So for the above example 03/09/22 02:13PM (MM/DD/YY hh:mmA) then becomes 03-09-2022 (MM-DD-YYYY):
You can find out more about changing date formats with Formatter here: Modify date and time formats in Zaps
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
