2 excel for comparison formula
If the table 2, before an entry in the employee's date of birth, after an entry is to participate in the working hours of employees, date of birth would like to check whether or not to participate in working hours is less than, and the formula, thank you! !
time to enter the correct format, such as 2008-10-10
the assumption that the importation of out A date of birth, B out input Participate in the working hours
C1 enter the formula = if (A1 <B1, “date of birth is less than the working hours” and “not less than date of birth working hours”)
C1 formula can be copied down
Added:
formula is input in the third set, if the original data in the third set, you can insert a column B in the auxiliary out (C out at third column)
In addition, the formula to Under the copy, if the B list the date of Health data, there is no space, you can double-click the cell C1 of the fill handle, you can quickly copy the formula in the end all of a sudden
Leave a Reply
You must be logged in to post a comment.