Compare Now Date from Excel Date


#1

Here I have 2 excel first is Data Data.xlsx (524.7 KB)
And Second Holiday.xlsx (1.9 MB) Sheet2 is Holiday so

step1: get difference between system Current date and Entry Date (Column G) from Data.xlsx in variable DayCount

Step2: Check no of holiday in between system Current date and Entry Date from Holiday.xlsx in variable NoOfHoliday

Please provide solution for that


#2

@suraj23 what exactly u want to do with holiday excel after calculating difference between from data excel?


#3

for Ex Entry date is 12-Mar-2018 (From Column G in Data.xlsx) and current Date is 20 Jul 2018, then calculate difference which is 130 Days then calculate Number of Holidays(Sheet2 Holiday.xlsx) present in between 12-mar-2018 to 20-jul-2018 which is 31 Holidays, ie total working day is 130-31=99 days


#4

What you have tried? Till so far? any idea do you have to approach or solve such prob?

Regards…!!
Aksh


#5

ok wait send u my sample program for demo.Now i have to compare the date with current date and then abv holiday.xlsx steps after comparison of entry date and current dateMain.xaml (12.7 KB)
Data.xlsx (525.5 KB)
Holiday.xlsx (1.9 MB)


#6

@Manjuts90 Is below values are correct?

Capture


#7

yes its correct, please can you send xaml or source code file


#8

@suraj23

DiffBetween2DatesExcludeHolidays.xaml (24.9 KB)


#9

@Manjuts90 actually i didnt understand 1 thing is
My entry date in data.xlsx is 13-oct-2017 right and current date is 23-july-2018
so its right difference is=283
but if i check holidays in between 13-oct-2017 till today its 65 days holidays r there and u get 42 how u calculate it should be 283-65=218 present days


#10

@suraj23 thats y i asked u to check the data present in screenshot is correct or not. U said correct thats y provided the workflow.


#11

ya sry for that because wsn’t calculate holiday data see upto 283 ua going correct only problem is from given date till today date holidays u get 42 but in my holiday.xlsx sheet2 there are 65 holidays till today.have to check that if codition may b for correct count


#12

@suraj23 i wil check and let u know


#13

ya thanks a lot


#14

@suraj23 Check if below values are correct in screenshot.

Capture

If above values correct, try below workflow

DiffBetween2DatesExcludeHolidays.xaml (24.0 KB)


#15

yes now its going well…@Manjuts90 thanks a lottttt…its really helpful,thanks for ua time.


#16

@suraj23 ur welcome