Error in Excel Date Formula

[Senthil_anand (Senthil)]

Hi Friends,

While Creating Data Array for creating worksheet, one column need to use date Formula(“=Date(Year,Month,Day)”). But while doing automation the output excel sheet showing same equation format, when I double-click the cell then the value is changing to date format.

Example: Column A contains Month, Column B contains Day and Column C contains Year. I need Date in Column D. Output excel sheet showing “=Date(C2,A2,B2)”. WHen i double click the cell and press enter then it will changes to “08/15/2019”.

We entered the code as follows:
{Convert.ToInt32(row(0).ToString),Convert.ToInt32(row(1).ToString),row(3).ToString,“”,(“=DATE(2019,”+“A”+Counter.ToString+“,”+“B”+Counter.ToString+“)”),row(2).ToString}

Can anyone help regarding this issue.

[bcorrea (Bruno Correa)]

Hi, welcome to the community!
This in my example is working fine, maybe you are building the formula in the wrong way:

[Senthil_anand (Senthil)]

Hello Sir,

Thanks for your reply. I will try your method.

[Pratik_Wavhal]

Hi @Senthil_anand

Try using the below thread :-

Runtime execution error with formula

I think the formula is =SUMIFS(D6:AH6,D3:AH3,"7"). Hence in UiPath I recommend you place the formula in a text file =SUMIFS(D<C2>:AH<C2>,D<C1>:AH<C1>,"7"), then read the file & do a .Replace("<C2>", YourCounter).Replace("<C1>", YourCounterVariable), then use the resulting string to write to cell. Hope that helps ! Kudos Regards, Nithin

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[Senthil_anand (Senthil)]

Hello Sir,

I tried your method. But result not come.

[bcorrea (Bruno Correa)]

Hi, can you share some part of your process and excel so we can test?