I need help writing a statement that essentially says if column A is the month of December in the following format xx/xx/xxxx. Then if column B has a number that starts with 23, 24, 25. Then if column O is Y or N.
I need help writing a statement that essentially says if column A is the month of December in the following format xx/xx/xxxx. Then if column B has a number that starts with 23, 24, 25. Then if column O is Y or N.
You can shorten your formula slightly...=IF(AND(MONTH(A23)=12,OR(LEFT(B23,2)="23",LEFT(B23,2)="24",LEFT(B23,2)="25"),O23="Y"),"Y","N")
Why are you trying to force the "in this format xx/xx/xxxx"? Dates in Excel are just whole numbers (the count of days since "day 0"... the day before January 1, 1899), what you see in the cell is for human convenience... Excel does not use it.Would it be possible to attempt a wrap up statement that would say something like if column A = the month of December in this format xx/xx/xxxx and if column B has the 23,24,25 in them and then if column O is Y.