Hi @atcodedog05 ,
I have two excel files
1)File1: 2021m07
2)File2: Final_report_07_2021
File1 is empty and File2 has a data.
Requirement:
File2 has columns with the month names.
I have to Sum these columns amount in a way that it adds up from Jan to present month.
For Example: These files are for month July , so it should add (Jan to Jul)/1000
For the next month it should add from (Jan to August)/1000
Desired_Output:
Result
381
My approach : i thought to take the month name from File name and map it with the column month name.
Can you help to solve this in better way or with my approach?
Regards
Areeba
Solved! Go to Solution.
Hi @areeba
It would be something like this. But your values don't seem to match please check on that.
Workflow:
Hope this helps : )
Happy to help : ) @areeba
Cheers and have a nice day!
Hi @atcodedog05 ,
I have a similar situation, only difference is my File name is '2021m07 IT Save Forecast' instead of 'Final_report_07_2021'. can you help me with the Regex to write in formula to extract month?
Regards
Areeba
Hi @atcodedog05 .
Thank you for the reply , after applying your regex i am getting this:
i think it should print 1400-07-01 instead of 2021-07-01, like you did in previous workflow.
Regards
Areeba
Hi @areeba
Try this formula
DateTimeParse(Right([FileName],20),"m%m IT Save Forecast")
Snapshot:
Hope this helps : )
Thanks