If function using dates in 2 cells [Closed]


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!!



Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!