Best answer

Autofill today's date in Excel

  • 20 August 2020
  • 3 replies

Userlevel 1

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 9 March 2022, 17:00

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 5
Badge +6

Depending what you’re doing after the spreadsheet step, you might be able to accomplish this with the TODAY function in Excel.

Userlevel 2

Just use {{zap_meta_human_now}}


Here’s the article on using it:


If you need only the date, try using a formatter step and transforming {{zap_meta_human_now}} to a format that suits you better.

Userlevel 7
Badge +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