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

Gangadhar_Athili (Gangadhar Athili) September 21, 2022, 11:15am 6

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