Find Friday Date of week 1

[saw15]

I am updating a quartely spreadsheet, and want to imput the end date of the first two weeks in cells. I then want to create a formula that will take that date, and populate the next worksheet, with the date for the following week's Friday date.

I know I can do a =RefCell + 14, but this does not work when the month changes etc, so I am looking for something that says ok, here is the last date, now I need next Fridays date, two weeks out.

Hope that was somewhat clear, any help you can provide is much appreciated.

Thanks in advance.

 

[xlhelp]

Friday this week
=NOW()+(6-WEEKDAY(NOW()))

Friday next week
=NOW()+(6-WEEKDAY(NOW()))+7

or replace NOW with TODAY



Me transmitte sursum, Caledoni!

 

[kjv1611]

Try checking Chuck Pearson's website out, specifically his portion on dates and times. He's got tons of really helpful information on his Excel website.

[URL unfurl="true"]http://www.cpearson.com/excel/DateTimeWS.htm[/url]

 

[AnotherHiggins]

I know I can do a =RefCell + 14, but this does not work when the month changes etc

When is 14 days after a Friday NOT a Friday?

Look at your calendar: Pick any Friday and count forward 14 days. You'll end up on a Friday every single time.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[kjv1611]

That's a good short formula for that, xlhelp! Have a star!