Calculate the date of the first friday following a date

**Oldeuboi** · 11-25-2012, 09:49 AM

Hi,

I have a date in A1, I would like a formula to return the next Friday date in A2

Example;

A1 = 25/11/12
A2 = 30/11/12

**Charlie_Howell** · 11-25-2012, 10:01 AM

=a1+8
Put this formula in the desired cell

**benishiryo** · 11-25-2012, 10:06 AM

hi again Oldeuboi. try:
=IF(WEEKDAY(A1,2)>=5,A1-WEEKDAY(A1,2)+12,A1-WEEKDAY(A1,2)+5)

**Palmetto** · 11-25-2012, 10:07 AM

=a1+(6-weekday(a1))

**Charlie_Howell** · 11-25-2012, 11:12 AM

here is another option

=IF(WEEKDAY(A1)=6,A1+7,IF(WEEKDAY(A1)=7,A1+6,(A1+6-WEEKDAY(A1))))

**Oldeuboi** · 11-25-2012, 11:47 AM

Thank you ALL!!!!!!

Re: Calculate the date of the first friday following a date