Hi, hoping for some help with a problem.
I am trying to build a cashing up sheet for use at my work, based on our new tills, which we can download daily reports from.
The idea being if I manually copy and paste the report into the top of the cash up sheet, hide it (with a group +/- button for convenience) then all the info will fill itself into the user friendly part of the sheet, we'll just have to count the money and its done.
The next step, would be a macro that does all that for me, which is what I'm working on.
The till system downloads the report sheet with a name such as "daily-cash-up-report-2021-09-04-2021-09-04" I can edit the "daily-cash-up-report" bit, but I can't edit the exports having the date range in their names.
So, no problem, I just have a cell in the sheet with today's date in it for reference.
So, in cell C60 I have =TODAY() and in cell D60 I have tried to enter a formula that will generate the name of the file which is going to be exported from the till:
="daily-cash-up-report-"&TEXT(RIGHT(C60,4),"YYYY")&"-"&TEXT(MID(C60,4,2),"MM")&"-"&TEXT(LEFT(C60,2),"DD")
I would therefore expect a return of: daily-cash-up-report-2021-09-04 (need to do date twice, but I'd like to get it right before complicating the sheet.
Instead it is returning: daily-cash-up-report-1912-02-13
What am I doing wrong?
Thanks!!!
I am trying to build a cashing up sheet for use at my work, based on our new tills, which we can download daily reports from.
The idea being if I manually copy and paste the report into the top of the cash up sheet, hide it (with a group +/- button for convenience) then all the info will fill itself into the user friendly part of the sheet, we'll just have to count the money and its done.
The next step, would be a macro that does all that for me, which is what I'm working on.
The till system downloads the report sheet with a name such as "daily-cash-up-report-2021-09-04-2021-09-04" I can edit the "daily-cash-up-report" bit, but I can't edit the exports having the date range in their names.
So, no problem, I just have a cell in the sheet with today's date in it for reference.
So, in cell C60 I have =TODAY() and in cell D60 I have tried to enter a formula that will generate the name of the file which is going to be exported from the till:
="daily-cash-up-report-"&TEXT(RIGHT(C60,4),"YYYY")&"-"&TEXT(MID(C60,4,2),"MM")&"-"&TEXT(LEFT(C60,2),"DD")
I would therefore expect a return of: daily-cash-up-report-2021-09-04 (need to do date twice, but I'd like to get it right before complicating the sheet.
Instead it is returning: daily-cash-up-report-1912-02-13
What am I doing wrong?
Thanks!!!