I think Power Automate Desktop is a great tool and have been able to automate some complex processes, but right now I'm stuck on something so simple! All I want to do is write a date into a cell in Excel, but whatever I try it writes text that Excel cannot recognise as a date. I've broken this down to the simplest example, start with an Excel file with a date in cell A1, open this file in PAD, read the value of A1, add 7 days to it and write the result back to the same cell. The result written back is text not a date. Don't know if it makes a difference, but I am in the UK, using UK date formats. I've checked everywhere, Windows, Office, Browser etc and all are set to the same UK language and date formats. My test Flow is below along with the result after I run it.
I'm sure I'm missing something incredible simple, but can't work out what that is!
