How to get all dates from current month?

want to write all the dates from current month in excel column

Hi @NervousTuber ,

Could you using this inside a For Each Activity and write the values one by one into Excel?

Enumerable.Range(1,DateTime.DaysInMonth(Today.Year,Today.Month)).Select(Function(s) New DateTime(Today.Year,Today.Month,s).ToString("dd-MM-yyyy")).tolist()

Kind Regards,
Ashwin A.K

Thanks for your help :slight_smile:

Hey, i am trying to write the data to specific range “A6” in sheet1

rather than writing the data to this sheet1 its creating another new sheet1 into same excel sheet what to do?

Pass the correct sheet name you are showing Sheet1 and already present is Sheet 1.


1 Like

Ohhh , thanks

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