Thank you! Although you didn't directly solve my problem you put me you the right path and my problem was solved!

Thanks! You've helped me a lot! :-)

Thank you for giving multiple ways ☺️

@FindEasySolution

3 жыл бұрын

You are welcome

if anyone is having issues, set the target output cell to a number type, not date type

@parktol02

3 жыл бұрын

That was my problem! Thanks!

@whoistlovesburbrryshouldst186

2 жыл бұрын

I was getting dollar amounts, thank you…you absolute legend!

@noobpullup

2 жыл бұрын

Thanks this resolved the issue

@lylestavast7652

Жыл бұрын

half an hour after messing with it, you provide the fix.... which wasn't quite in mind of course... TY

Thank you! Very helpful

@FindEasySolution

2 жыл бұрын

You are welcome

The video content is so excellent, congratulations

@FindEasySolution

2 жыл бұрын

Thank you for the appreciation

Thank you!

@FindEasySolution

3 жыл бұрын

You are welcome

thanks a lot for explaining in simple

@FindEasySolution

5 ай бұрын

You are welcome. Please subscribe to our channel.

Doesn’t work. What am I missing?

Hi can you help me with the formula to determine if there is an overlap between 2 ranges of date. Like for example first range is 01/01/2022 to 12/31/2022 second range is 12/01/202 to 12/31/2023 I would like to learn the formula to identify immediately if there is an overlap between this 2 range of dates. I appreciate your help!

Very helpful

@FindEasySolution

3 жыл бұрын

Glad to help

I want to calculate the days difference between 2dates excluding Saturday and Sunday. But the start date is as of current day.Example today 15/01/2023 and invoice date is 10/01/2023, the days difference is 4days, tomorrow the same will be calculated as of 16/01/23 (which best formula can used returning the value as positive)

If I have to use the current date and calculate daily..can I use a general formula for the start day instead of changing it to 15/01,16/01 etc ).also the value return as negative .how to keep as a positive value despite having the age difference?

If there are multiple months, and I want to know for each month how many days? Ex: (16-10-21 to 15-12-21) - October- 15 Days, Nov - 30 Days, Dec - 15 Days

Thanks sir..

@FindEasySolution

2 жыл бұрын

You are welcome

Thank you

@FindEasySolution

3 жыл бұрын

You are welcome.

Mine is subtracting the month and year and I only want to show days and I did the exact same thing

@gursharansidhu2421

3 жыл бұрын

if has two different month then

Thanks

@FindEasySolution

8 ай бұрын

You are welcome. Please subscribe to our channel.

This is so basic. How can we consider Business Days and Holidays?

@FindEasySolution

Жыл бұрын

Please watch this video kzread.info/dash/bejne/mXaK3NyccbnfkcY.html&ab_channel=FindEasySolution Please subscribe to our channel.

its not working in my laptop....????? anything missing

helpful

Can ecu calculate a specific day

it is showing #Value erroe.

How do I get the total weekdays returned without the weekend

@FindEasySolution

Жыл бұрын

Please watch this video, you can even use a custom weekend days as well kzread.info/dash/bejne/qKuazZuEe7iyabw.html

how to calculate number of months day's between 2 dates ?

@FindEasySolution

2 жыл бұрын

Please watch this video, you can use any date instead of date of birth kzread.info/dash/bejne/oo1ot6ikeJe4gNI.html

But from day 1 to 14 it should be 14 days right so how to use a formular for that?

@michelleanatole9842

2 жыл бұрын

That is what I need to know. :) If someone knows the answer please let me know

@dawerhouse8337

Жыл бұрын

@@michelleanatole9842 =(D5-C5)+1

How to calculate the number of days excluding holidays

@FindEasySolution

2 жыл бұрын

Please watch this video kzread.info/dash/bejne/qKuazZuEe7iyabw.html

@FindEasySolution

2 жыл бұрын

You can also check this video kzread.info/dash/bejne/mXaK3NyccbnfkcY.html

If calculated from 1/11 to 14/11 that's 14 days not 13 what I'm missing here !!

@FindEasySolution

3 жыл бұрын

Excel calculates as 14-1=13 days. It's like the number days between two dates.

@Chandresh_khantwal

3 жыл бұрын

@@FindEasySolution is there any formula for 14 answer

@qasmb1546

2 жыл бұрын

insert +1 at end of start date in the formula will fix this

@ICanMasti

Жыл бұрын

​@@qasmb1546 there is no other formula

Why value error is coming😢

the sound is not good I am quite disappointed

I am getting #VALUE! error

@FindEasySolution

3 жыл бұрын

Please give details of what you are trying to do.

@gshankar4u

3 жыл бұрын

if you change the format of the date then will work

@mirzamuhammad9858

3 жыл бұрын

@@gshankar4u Thanks a lot dear for your response. I have tried and it worked

@ICanMasti

Жыл бұрын

​@@gshankar4u why

@gshankar4u

Жыл бұрын

@@ICanMasti not able to understand what you are asking

Not working.

its giving me date not days

Don't work