Start and End dates between in range

Hi,
Assume.

Start date is in Column A

End Date Is in Column B

in 1st row End date is greater then start date

in second row

Ex : in 1st row Start Date 01-01-2021 End date -15-01-2021

in second row start date 02-01-2021 End date -20-01-2021( Not Acceptable ).need to show some error

Why Because the dates Are in Range

it should be in userform

please give me the suggestion.


Thanks in advance

Place this code in the sheet module you want for this actionto take place

Please Login or Register  to view this content.

Thanks For ur response

It not worked please go through my attached template.

Hi krishnaji.B,

What about this?

Originally Posted by DMA

Hi krishnaji.B,

What about this?

No its seems same like that only

If you enter the wrong date it will now show you an error saying "Check Dates", also it won't show the zeros. Try it.
It's not the same formula.

Same code applied to sample file

Hi
Thanks For ur Good response

But ican't achieve what i'm expecting.

You have two working solutions. Please explain why either doesn’t work for you and we could try to refine the process for you.