Best answer

Autofill today's date in Excel

  • 20 August 2020
  • 3 replies
  • 5896 views

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?

icon

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:  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.

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:
4535c077ef591714a9f168598fbe21b4.png
Would appear in Excel as 3/9/2022:
d4b62fcd12016133fcfc212afabd6123.png

And using {{zap_meta_human_now}} would add both the current date and time. 

20eacc922001a951c98915fe7ff39be8.png
So it would appear in MM/DD/YY hh:mmA format:
4aa98b599ae676a1ef29bebdbb0e792c.png

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:
14b432ba8d5c934fafd9088514fe7f2f.png
So for the above example 03/09/22 02:13PM (MM/DD/YY hh:mmA) then becomes 03-09-2022 (MM-DD-YYYY):
0cafe64f055badc251241530ae7e8fb2.png
You can find out more about changing date formats with Formatter here: Modify date and time formats in Zaps