Displaying Week End Date

  • Thread starter Thread starter SamuelT
  • Start date Start date
S

SamuelT

Hi all,

I've got a spreadsheet where I need to display the week end date (being
every Friday).

I know there is a means of showing the current date, time, etc. Is
there are means of getting Excel to look at this and work out what the
date on Friday will be?

TIA,

SamuelT
 
=A1-WEEKDAY(A1,2)+5

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
If Sat and Sun should shift to next Friday, try

=A1-WEEKDAY(A1,2)+5+(WEEKDAY(A1,2)>5)*7

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Hi all,

I've got a spreadsheet where I need to display the week end date (being
every Friday).

I know there is a means of showing the current date, time, etc. Is
there are means of getting Excel to look at this and work out what the
date on Friday will be?

TIA,

SamuelT
Click to expand...


=A1-WEEKDAY(A1+1)+7


--ron
 
You must log in or register to reply here.

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

week numbers 3
Auto Sheet Names and Date cells 3
Formula to display next Friday from B1 works except on the Friday itself. 4
How do I set a cell to auto populate the date to show the current week's Friday date? 4
Day and Date Autofill 7
Help to Highlight Excel Row based on Weekly Date Range 2
calculating the number of pay-dates before a bill is due? 4
Nest vs Hive? 10

Back
Top