I have two dates as 01/January/2023 as start date and 21/January/2023 as End date. I have to get all dates in weekly wise

Help Studio
, ,
1

Hi all,
i have two dates as 01/January/2023 as start date and 21/January/2023 as End date. I have to get all dates in weekly wise like 1/January/2023 to 7/January/2023 in one Excel sheet and another seven dates in another Excel sheet . But all should be in same Excel file but different Sheets. Please help me guys. Thanks in advance.

2

Hello @mrupendrareddy123

  1. Read all the excel files one by one, using workbook read range activity.
  2. Use Write range for 1st time and use append range on same file.
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.