VBA or Formula to tell me if the Date in Column C is less than Column B

[APML]

Hi all, I have 2 columns. Column B is an “Entry Date”, and Column C is an "Exit Date".

Column B starts at B7 and finishes at B3000 Column C starts at C7 and finishes at C3000

They will always only be direct comparisons i.e B70 will only be compared to C70
And if either cell is empty, then I don't want anything



Basically, I need a formula that will tell me if the Date in Column C is less than the Date in Column B
They can and often will be the same date, or Column C will be higher.

Here is an example:
Let’s say in B100 I have the date 02/10/22 (day, mth, year) and in C100 I accidentally put in 01/10/22, then I’d want something like “Exit Date cannot be less than Entry Date”.

I understand that I could put an if statement in Column D and copy all the way down D300

But was hoping I could just do the whole thing with 1 formula or VBA

Thanks for reading this and I really appreciate any help given

 

[alansidman]

An option is to use Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Entry", type date}, {"Exit", type date}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each if[Exit]<[Entry] then 1 else null)
in
    #"Added Custom"

 

[APML]

An option is to use Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Entry", type date}, {"Exit", type date}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each if[Exit]<[Entry] then 1 else null)
in
    #"Added Custom"

To hard for this application