Date of a certain day of the week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have Excel automatically put the date of a specific day of the week in a cell? I submit a timesheet every Tuesday. I would like the date of the next Tuesday automatically displayed in the Date submitted cell on the worksheet
 
Try this

=TODAY()+3-WEEKDAY(TODAY())

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

DJungst said:
Is it possible to have Excel automatically put the date of a specific day
Click to expand...
of the week in a cell? I submit a timesheet every Tuesday. I would like
the date of the next Tuesday automatically displayed in the Date submitted
cell on the worksheet
 
Hi,

Bob's formula gives you the Tuesday of this week (given weeks are from Sunday to
Saturday).

If you need next Tuesday (if today is a Wednesday, find the next Tuesday):
=TODAY()-WEEKDAY(TODAY()-2)+8

If you need the current/next Tuesday (if today is a Tuesday, stay on that day,
else find next Tuesday):
=TODAY()-WEEKDAY(TODAY()-3)+7

Regards,

Daniel M.
 
Back
Top