Re: Converting the date format when writing to excel
Hello,
thanks a lot! It displays things correctly in excel.
However, the dates don't work in the same way as the ones I get from Forms when it gives me the date and time submitted.
As far as the data goes, it seems to me that what I get in excel from Forms is a number that Excel converts to a date.
And Powerautomate now sends an already converted date, that excel display correctly, but does not calculate correctly... if that makes any sense.
The last entry in the following table comes from the Flow I built with your formula (thanks again for that!)
The other entries come from a flow that adds rows whenever a form is submitted to Forms.
I have conditional formatting in that table that will highlight entries that are above average (as in: newest) in green and the last 10 % red, so the person monitoring can tell at a glance whom they should maybe ask to update their numbers.
This is really a minor thing, but now that I'm getting into dates, I'm curious if it can be resolved.
For some background: I am giving 8 different groups of people two options to submit data to that table. The heads of the organisation will be able to use a powerapp to submit data and check when and what their organisation submitted last. And they can delegate submitting data to other people by giving them the link to their organisation-specific Form.
