Displaying Week End 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
 
B

Bob Phillips

=A1-WEEKDAY(A1,2)+5

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

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)
 
R

Ron Rosenfeld

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
 
Top