Hello all, I have a scenario like in Excel in colum B I have some dates and in column A I have some different dates so I need to check that the date in column A should not be within 30 days from column B. How can I check this condition. Thank you

Hi @sanjay_gowda Kindly refer to this Xaml file, You may get some idea. Forum_Date_Compare_Excel.zip (74.5 KB) Beyond +or-30 days from Colum B, Column A should filter

Excel automation for finding dates

Help Studio

Gokul_Jayakumar (Gokul Jai) September 21, 2022, 8:03am 2

@sanjay_gowda Kindly share some sample inputs

Topic		Replies	Views
Compare two Columns in Excel and check if first columns dates are more than 30 days for the second column Studio studio , question , activities_panel	11	1014	July 29, 2022
Filter date column in datatable Activities datatable , excel	14	1707	September 26, 2021
Date compare with Linq Help activities	10	2674	October 8, 2020
Checking if cell dates are between now and 30 days time Help	6	3397	October 29, 2018
Good Afternoon! Everyone I have an excel sheet in that different dates are there. I want to now that date is more than 18 days or not. Please can any one help in this Studio activities , question	33	1208	February 23, 2020

Excel automation for finding dates

Related topics