Hi
i want to write a linq query where i have an excel with data rows input data.xlsx and value in var = 01/01/2025
now i want to do is write a query so an excel in below format can be created
for each row i want to write 3 rows all details will be same b=only thin will change is start date and end date will be consecutive month 1st and last date as Jan is month the
start date will be 01-01-2025 end date 31-01-2025
01-02-2025 end date 28-02-2025
01-03-2025 end date 31-03-2025 sample out put in attachment
that is for each row of data in we will have to generated 3 row of data in consecutive month data
input data.xlsx (8.3 KB)
output.xlsx (8.6 KB)