Hi All,

I have to provide a date for 2 variables

A1 will need 3 days added and A2 needs 2 days added

I have entered into A3 the following but need the formula for the 2 days
also in A3....I'm stuck

=IF(WEEKDAY(A1+3)=1,A1+5,IF(WEEKDAY(A1+3)=7,A1+6,A 1+3))

cheers Paul

=A1+3+(WEEKDAY(A1+3)=1)+(WEEKDAY(A1+3)=7)*2

--
__________________________________
HTH

Bob

"Paul" wrote in message
...
Hi All,

I have to provide a date for 2 variables

A1 will need 3 days added and A2 needs 2 days added

I have entered into A3 the following but need the formula for the 2 days
also in A3....I'm stuck

=IF(WEEKDAY(A1+3)=1,A1+5,IF(WEEKDAY(A1+3)=7,A1+6,A 1+3))

cheers Paul

THanks Bob,

Looking at my question I dont think I was clear. I need to add 3 days if A1
is populated so my formula works however sometimes A1 will be blank and A2
will be populated with a date. A3 need to pick up either not both as this
will never happen

"Bob Phillips" wrote:

=A1+3+(WEEKDAY(A1+3)=1)+(WEEKDAY(A1+3)=7)*2

--
__________________________________
HTH

Bob

"Paul" wrote in message
...
Hi All,

I have to provide a date for 2 variables

A1 will need 3 days added and A2 needs 2 days added

I have entered into A3 the following but need the formula for the 2 days
also in A3....I'm stuck

=IF(WEEKDAY(A1+3)=1,A1+5,IF(WEEKDAY(A1+3)=7,A1+6,A 1+3))

cheers Paul

Aren't you trying to bypass weekend with the new date as well?


--
__________________________________
HTH

Bob

"Paul" wrote in message
...
THanks Bob,

Looking at my question I dont think I was clear. I need to add 3 days if
A1
is populated so my formula works however sometimes A1 will be blank and A2
will be populated with a date. A3 need to pick up either not both as this
will never happen

"Bob Phillips" wrote:

=A1+3+(WEEKDAY(A1+3)=1)+(WEEKDAY(A1+3)=7)*2

--
__________________________________
HTH

Bob

"Paul" wrote in message
...
Hi All,

I have to provide a date for 2 variables

A1 will need 3 days added and A2 needs 2 days added

I have entered into A3 the following but need the formula for the 2
days
also in A3....I'm stuck

=IF(WEEKDAY(A1+3)=1,A1+5,IF(WEEKDAY(A1+3)=7,A1+6,A 1+3))

cheers Paul

Yes and bank holidays. The formula in A3 currently as shown works great for
data in A1 ,I just dont know how I can add

=IF(WEEKDAY(A2+2)=1,A2+5,IF(WEEKDAY(A2+2)=7,A1+6,A 2+2))

into A3 also.

"Bob Phillips" wrote:

Aren't you trying to bypass weekend with the new date as well?


--
__________________________________
HTH

Bob

"Paul" wrote in message
...
THanks Bob,

Looking at my question I dont think I was clear. I need to add 3 days if
A1
is populated so my formula works however sometimes A1 will be blank and A2
will be populated with a date. A3 need to pick up either not both as this
will never happen

"Bob Phillips" wrote:

=A1+3+(WEEKDAY(A1+3)=1)+(WEEKDAY(A1+3)=7)*2

--
__________________________________
HTH

Bob

"Paul" wrote in message
...
Hi All,

I have to provide a date for 2 variables

A1 will need 3 days added and A2 needs 2 days added

I have entered into A3 the following but need the formula for the 2
days
also in A3....I'm stuck

=IF(WEEKDAY(A1+3)=1,A1+5,IF(WEEKDAY(A1+3)=7,A1+6,A 1+3))

cheers Paul

This should so what you want

=WORKDAY(IF(ISNUMBER(A1),A1,A2),2,holidays)

where holidays is a range of holiday dates

--
__________________________________
HTH

Bob

"Paul" wrote in message
...
Yes and bank holidays. The formula in A3 currently as shown works great
for
data in A1 ,I just dont know how I can add

=IF(WEEKDAY(A2+2)=1,A2+5,IF(WEEKDAY(A2+2)=7,A1+6,A 2+2))

into A3 also.

"Bob Phillips" wrote:

Aren't you trying to bypass weekend with the new date as well?


--
__________________________________
HTH

Bob

"Paul" wrote in message
...
THanks Bob,

Looking at my question I dont think I was clear. I need to add 3 days
if
A1
is populated so my formula works however sometimes A1 will be blank and
A2
will be populated with a date. A3 need to pick up either not both as
this
will never happen

"Bob Phillips" wrote:

=A1+3+(WEEKDAY(A1+3)=1)+(WEEKDAY(A1+3)=7)*2

--
__________________________________
HTH

Bob

"Paul" wrote in message
...
Hi All,

I have to provide a date for 2 variables

A1 will need 3 days added and A2 needs 2 days added

I have entered into A3 the following but need the formula for the 2
days
also in A3....I'm stuck

=IF(WEEKDAY(A1+3)=1,A1+5,IF(WEEKDAY(A1+3)=7,A1+6,A 1+3))

cheers Paul