cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
omarkb
Frequent Visitor

Update dates in a cell

I have two cells, I want to update cell one with today's date and cell two with tomorrow's date. I want this process to run daily and then refresh the data.

Is this possible in power automate?

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @omarkb ,

 

Unless the two cells are in a table, this is not possible(You can use your own Excel file, but the data must be formatted as a table. For more information, see Format a table.).

 

I recommend that you use Excel's Today() function directly without using Flow.

 

vbofengmsft_0-1657609989358.png

 

Best Regards,

Bof

View solution in original post

3 REPLIES 3
Shuvam-rpa
Super User
Super User

@omarkb sharepoint list or excel??

omarkb
Frequent Visitor

excel

v-bofeng-msft
Community Support
Community Support

Hi @omarkb ,

 

Unless the two cells are in a table, this is not possible(You can use your own Excel file, but the data must be formatted as a table. For more information, see Format a table.).

 

I recommend that you use Excel's Today() function directly without using Flow.

 

vbofengmsft_0-1657609989358.png

 

Best Regards,

Bof

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (2,591)