How to compare each excel date column with system current date

Help
, , ,
1

Capture

Hello All

                     how to compare each column of dates in excel sheet with current system date to check the attendance of employee i have shared the excel image.

Thanks,
Pranay

2

Hi @pranay.a
You can add the date value from here (try specifying the data using cell range) to a data table, and then by using for-each loop you can check each date with today’s date.
I think it will help you.
Thanks

3 Likes
3

@pranay.a

Can you please mark it as a solution if it helped you.

Thanks

4

Dt1.Columns.Contains(Now.ToString(“dd-MM-yyyy”))

used this to check the current system date with excel column date in if condition

5

Great.

Thankyou

1 Like
6

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