Need formular to use with dates

N

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.
 
M

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
 
L

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.
 
J

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top