Need formular to use with dates

[NICKJAX]

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.

 

[Mike H]

Hi,

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

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

Mike

 

[Luke M]

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.

 

[Jason]

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]

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

 

[Mike H]

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

 

[Glenn]

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

 

[NICKJAX]

It works, I was doing something wrong...

Thanks a million for your help!!!!!