Filter Fields and then Differentiate date to get days


#1

hello,
i have one excel sheet in it there are different column’s,In “Mode” column there are different Fields like Auto Debit,ECS,NACH(U will get that fields when u put filter to it) so what i want to do is:
No. of Days FOR ECS, AUTO DEBIT AND NACH (System date - VALUE Date ) and Calculate Total days,Working Days(by removing holidays & week off in respective months) .here i send u my excel sheetRawData.xlsx (127.9 KB)
aging.xlsx (1.6 MB)


#2

i have to fill columns of No. of Days,Working Days using above operations


#3

@suraj23 Compare Now Date from Excel Date


#4

ya Manjuts90 but now we have extra column like mode and system date is 22-May-18 and value date is in this format 03.05.2018 so giving error


#5

please share the logic of abv


#6

Not clear what do you want


#7

i have one excel sheet RawData which i sent above,if i put filter to Mode Column There are filelds like ECS, AUTO DEBIT…
and i have other columns likes days,Working Days which are empty first time and i want to fill it using this logic:
No. of Days FOR ECS, AUTO DEBIT AND NACH (System date - VALUE Date ) and Calculate Total days,Working Days(by removing holidays & week off in respective months) .
Holiday list is:aging +


#8

System Date-value date col also there in RawData want its difference means days and with the help of aging want to find working days and fill in main excel