Date formula to select Fridays only.

**singerbatfink** · 11-29-2011, 05:44 AM

Hi my working week commences on a Saturday through to Friday,

I need a formula that will show what the Friday date is within that week if another date is input from within the same week.

Say I input last Sundays date 27/11/2011, I'd like the formula to return 02/12/2011 (Friday)

Hope that makes sense.

BMC

**sweep** · 11-29-2011, 05:57 AM

Hi,

This will return the friday following the date in A1

=A1+6-WEEKDAY(A1)

**daddylonglegs** · 11-29-2011, 06:31 AM

Originally Posted by sweep

This will return the friday following the date in A1.....

.....not if A1 is a Saturday.....that will show the day before. If you want the following Friday shown on a Saturday amend formula to

=A1+7-WEEKDAY(A1+1)

**singerbatfink** · 11-29-2011, 06:35 AM

Hi Sweep,

Thanks for that but when I changed the date to last Saturdays date it has returned the Fridays date from the previous week.
My week runs from Sat-Fri inclusive and I'd like the formula to show the Friday within that range.

The dateb id like returned would be 02/12/2011 if the 26/11/2011 was input in A1.

Is that possible?

Thanks

**singerbatfink** · 11-29-2011, 06:48 AM

Thanks daddylonglegs. That's perfect.

Would be be able to break that formula down for me, or can you suggest and where I can look for some guidance.

Cheers