Create excel file if Date is 1st date of every month

Help Activities
, ,
1

Hi,

i want to create excel file for every month , when it start with first date.
for exp–>if date come 02-01-2022 then to create new excel file otherwise don’t create excel file.
how to write this condition?
can any one help ?

2

Hello @Anand_Designer

Probably like this

If Today = Today.AddDays(-(Today.Day-1)) Then create Excel file
(if today date = first date of the current month)