Adding Values for specific date in column using linq

Hi @mkankatala ,
I want to add the values for specific dates. please find the attached excel for reference, Sheet 1 is the input, Sheet 2 is the expected output.
SampleFile.xlsx (9.9 KB)

Thanks in advance.

Hi @Suma1993

We have alredy did this part right,
image

What do you want to do now… Could you be more specific.

Hi @mkankatala , i want to have the total of particular column amount for that specific date, before we had multiple Dates in first column but now we wont be having that “Date” column (sheet1) and todays date will be added in output table as in sheet2.