hi,
im trying to learn date manipulation thru formulas
i have a manually inputted date value in A2
then a weekday function value in B2 =WEEKDAY(A2)
then a formula in C2 =IF(OR(B2=1,B2=7),DATE(YEAR(A2),MONTH(A2),DAY(A2)-1),A2)
which shows the previous day of the date value of A2 if B2 is 1 or 7
how do i include in the formula of C2 to search also the values of N2:N6 which has the same date?
so in turn in C2 it would show the previous day of the date value of A2 if B2 is 1 or 7 or if the date value of A2 is also in the range of N2:N6
attached file as suggested
Bookmarks