Change format column from "General" to "Date"

[kumar.varun2 (Varun Kumar)]

@prasath17

If I have known the DateTime.FromOADate() earlier it could have saved a lot of hassle in solving the problem in this post

Convert month data into day wise data

Hi @manjesh_kumar Please check the xaml attached if it solves your problem 90 Rows per Line.xaml (9.2 KB) Also, the input and the output you have sent are not correct. Please check cell D369 of your Input sheet. It is not null. Before running the workflow please delete the content of cell D369. [image] The output is also not correct [image] The highlighted values must be 32.26 (Am I right?) Please let me know if the solution works for you.

Thanks @prasath17
Learned an interesting method today.