Hi, I was trying to use the Formula SUMIF.

What I need is to have two colums, one with Dates and the other one with
results.

I need a formula to recognize if the date of the week is a Friday, the
Result column should read original date + 4 days added to the original date.
Example. If Date colum reads Friday, July 24, 2009 the Result column should
read 07/29/09 or Wednesday,July 29,2009 Any other day of the week I just need
to add 2 days.

Hi,

Assuming your dates are in A1 down put this in b1 and drag down

=IF(WEEKDAY(A1)=6,A1+5,A1+2)

Mike

"NICKJAX" wrote:

Hi, I was trying to use the Formula SUMIF.

What I need is to have two colums, one with Dates and the other one with
results.

I need a formula to recognize if the date of the week is a Friday, the
Result column should read original date + 4 days added to the original date.
Example. If Date colum reads Friday, July 24, 2009 the Result column should
read 07/29/09 or Wednesday,July 29,2009 Any other day of the week I just need
to add 2 days.

Hi Mike, this is giving me a #NAME? error, any suggestion? thanks!

"Mike H" wrote:

Hi,

Assuming your dates are in A1 down put this in b1 and drag down

=IF(WEEKDAY(A1)=6,A1+5,A1+2)

Mike

"NICKJAX" wrote:

Hi, I was trying to use the Formula SUMIF.

What I need is to have two colums, one with Dates and the other one with
results.

I need a formula to recognize if the date of the week is a Friday, the
Result column should read original date + 4 days added to the original date.
Example. If Date colum reads Friday, July 24, 2009 the Result column should
read 07/29/09 or Wednesday,July 29,2009 Any other day of the week I just need
to add 2 days.

Hi,

You shouldn't get that if you spelt the formula correctly. Don't retype it
copy and paste it and see if that works.

Mike

"NICKJAX" wrote:

Hi Mike, this is giving me a #NAME? error, any suggestion? thanks!

"Mike H" wrote:

Hi,

Assuming your dates are in A1 down put this in b1 and drag down

=IF(WEEKDAY(A1)=6,A1+5,A1+2)

Mike

"NICKJAX" wrote:

Hi, I was trying to use the Formula SUMIF.

What I need is to have two colums, one with Dates and the other one with
results.

I need a formula to recognize if the date of the week is a Friday, the
Result column should read original date + 4 days added to the original date.
Example. If Date colum reads Friday, July 24, 2009 the Result column should
read 07/29/09 or Wednesday,July 29,2009 Any other day of the week I just need
to add 2 days.

It works, I was doing something wrong...

Thanks a million for your help!!!!!

"Mike H" wrote:

Hi,

You shouldn't get that if you spelt the formula correctly. Don't retype it
copy and paste it and see if that works.

Mike

"NICKJAX" wrote:

Hi Mike, this is giving me a #NAME? error, any suggestion? thanks!

"Mike H" wrote:

Hi,

Assuming your dates are in A1 down put this in b1 and drag down

=IF(WEEKDAY(A1)=6,A1+5,A1+2)

Mike

"NICKJAX" wrote:

Hi, I was trying to use the Formula SUMIF.

What I need is to have two colums, one with Dates and the other one with
results.

I need a formula to recognize if the date of the week is a Friday, the
Result column should read original date + 4 days added to the original date.
Example. If Date colum reads Friday, July 24, 2009 the Result column should
read 07/29/09 or Wednesday,July 29,2009 Any other day of the week I just need
to add 2 days.

Copied directly from Mike's post, no error. Post your version of the formula.

NICKJAX wrote:
Hi Mike, this is giving me a #NAME? error, any suggestion? thanks!

"Mike H" wrote:

Hi,

Assuming your dates are in A1 down put this in b1 and drag down

=IF(WEEKDAY(A1)=6,A1+5,A1+2)

Mike

"NICKJAX" wrote:

Hi, I was trying to use the Formula SUMIF.

What I need is to have two colums, one with Dates and the other one with
results.

I need a formula to recognize if the date of the week is a Friday, the
Result column should read original date + 4 days added to the original date.
Example. If Date colum reads Friday, July 24, 2009 the Result column should
read 07/29/09 or Wednesday,July 29,2009 Any other day of the week I just need
to add 2 days.

While it sounds like it, that's not the context for SUMIF (see XL help file
for further info). For your scenario, Assuming original date is in A2:
=A2+IF(WEEKDAY(A2)=6,4,2)
Format cell to desired date format.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"NICKJAX" wrote:

Hi, I was trying to use the Formula SUMIF.

What I need is to have two colums, one with Dates and the other one with
results.

I need a formula to recognize if the date of the week is a Friday, the
Result column should read original date + 4 days added to the original date.
Example. If Date colum reads Friday, July 24, 2009 the Result column should
read 07/29/09 or Wednesday,July 29,2009 Any other day of the week I just need
to add 2 days.

Assuming cell A1 contains a date, the following formula will add 4 days
if the date is a friday, and 2 days for all other days of the week:

=IF(WEEKDAY(A1)=6,A1+4,A1+2)

Jay
--


NICKJAX wrote:
Hi, I was trying to use the Formula SUMIF.

What I need is to have two colums, one with Dates and the other one with
results.

I need a formula to recognize if the date of the week is a Friday, the
Result column should read original date + 4 days added to the original date.
Example. If Date colum reads Friday, July 24, 2009 the Result column should
read 07/29/09 or Wednesday,July 29,2009 Any other day of the week I just need
to add 2 days.