Need formular to use with dates
 

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.

Need formular to use with dates
 

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.

Need formular to use with dates
 

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.

Need formular to use with dates
 

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.

Need formular to use with dates
 

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.

Need formular to use with dates
 

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.

Need formular to use with dates
 

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.

Need formular to use with dates
 

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.