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.