Excel condition12

Hi All,

I want to put a condition after doing the data scrapping from a website as follows:


From the image how to put the condition like:
Deposit / Posting Date is column name contains or equals to (currentdate, day-1 date, day-2 date, day-3 date) in the format("MM/dd/yyy).

for example current date is: 07/12/2023
day-1 date means : 07/11/2023
day-2 date means: 07/10/2023
day-3 date means 07/09/2023)

I meant after scrapping the data using data scrapping I need to check the condtion the column
“Deposit / Posting Date” contains 07/12/2023 then I need to some action, in the same I need to find for last 3 days from current date.

Please do helpful.

@vishal.kp
@ushu
@supriya117
@ppr
@Naveen_KK1
@Gokul001
@Yoichi

Hi @Vrishchik

For current date:
DateTime.Now.ToString(“MM/dd/yyyy”)
For day -1:
now.AddDays(-1).ToString("MM/dd/yyyy")
For day-2:
now.AddDays(-2).ToString("MM/dd/yyyy")
For day-3:
now.AddDays(-3).ToString("MM/dd/yyyy")

Pass these four variables into an array and then compare.

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