For a formula solution assuming the date or interest is in A2
=IF(WEEKDAY(A2)=7,A2+6,A2+6-WEEKDAY(A2))
Tom Wood

"Celtic_Avenger " wrote in
message ...
Hi again.

In a spreadsheet I am creating I require it to show to dates.

The first is very simple as it is todays date:

Today()

The second I cant work out.

I need the second date to show the next friday after the Today date,
except if Today's date is a friday when it should show that.

Can anyone give me a hand with the formula or code for this?

Thanks

Celtic_Avenger



---
Message posted from http://www.ExcelForum.com/