Date formula excluding 1 day
Thanks, just needed to change one small part,
=IF(WEEKDAY(A1,2)+1<5,A1+1,A1+2) otherwise it would skip thursdays not
fridays. Thanks anyways.
"Mike H" wrote:
Hi,
Put your start date in (say) A1 and this in A2 and drag down
=IF(WEEKDAY(A1)+1<5,A1+1,A1+2)
Mike
"art" wrote:
Hello:
I'm looking for a formula that would reflect the following:
saterday - thursday.
Should only reflect days from above but skip
friday when drag/drop through the column.
|