Followinf Friday of a certain day

  • Thread starter Thread starter Alfredo_CPA
  • Start date Start date
A

Alfredo_CPA

I have in cell "A5" one day of the month
I need a formula in "A6" that gives me the following
friday of that specific day based on the input on "A5"

Any ideas??
Thanks
 
Thanks John
It works perfect
P.S. for other members: the formula gives you the following Friday of that
day (including the day itself ). If you don;t want to include the day itself
then, please use
Peo posting
 
Thanks Peo
It works perfect
P.S. for other members: the formula gives you the following Friday of that
day (without including the day itself ). If you want to include the day
itself then, please use John posting
 
Thanks for the feedback :D
--
John C


Alfredo_CPA said:
Thanks John
It works perfect
P.S. for other members: the formula gives you the following Friday of that
day (including the day itself ). If you don;t want to include the day itself
then, please use
Peo posting
Click to expand...
 

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

Similar Threads

Last Friday of the month 9
offset formula 3
How to get the cell reference of the value selected from name list 3
Day of the week 3
Formula to get number of days excluding Fridays in a given period 17
No of Days between two dates and offset formula 4
Hide columns based on row values 2
Variable Sumproduct Range 6

Back
Top