M
mlv
I'm using the formula below to find Saturday's date within the same week of
any date entered in A1.
=FLOOR(A1+5,7)
The formula works fine, but I now want to find Friday's date within the same
week of any date in A1.
I understand how the date in A1 (as a serial number) has 5 added to it and
the result is then rounded down to the nearest multiple of 7.
Does this type of formula only work for Saturday, or is there a similar
formula that will find Friday's date instead.
Otherwise, I guess I'll enter: =(FLOOR(A1+5,7)-1)
Thanks,
any date entered in A1.
=FLOOR(A1+5,7)
The formula works fine, but I now want to find Friday's date within the same
week of any date in A1.
I understand how the date in A1 (as a serial number) has 5 added to it and
the result is then rounded down to the nearest multiple of 7.
Does this type of formula only work for Saturday, or is there a similar
formula that will find Friday's date instead.
Otherwise, I guess I'll enter: =(FLOOR(A1+5,7)-1)
Thanks,