Date of a certain day of the week

[DJungst]

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

 

[Bob Phillips]

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)

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

 

[Daniel.M]

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.