If function using dates in 2 cells [Closed]

Report
-
Hello,

I am trying to format a cell using the iF function for dates in 2 cells. Eg If the date is equal to or less than Jan1st in B2 and Greater than or equal to Jan 1 in A2, the value is 1 if true and 2 if false. Tried various things but excel wouldn't accept it. Help please!!

Thanks

Hafis

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!