# Date troubles

#### kulmjord

##### Board Regular
Hey guys,

I am currently working on a spread sheet that requires me to display the date on specific days (example: only on Tuesdays will a date show), is there an IF function or something similar that will allow me to achieve this?

Many thanks.

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Is this what you need (3 is for Tuesday)?

=IF(WEEKDAY(TODAY())=3,TODAY(),"")

Hi,

You could try something like this:
Excel 2013
AB
1DateLabel
201/12/2016
302/12/2016
403/12/2016
504/12/2016
605/12/2016
706/12/2016Tue 06/12/2016
807/12/2016
908/12/2016
1009/12/2016
1110/12/2016
1211/12/2016
1312/12/2016
1413/12/2016Tue 13/12/2016
Sheet1
Cell Formulas
RangeFormula
B2=IF(WEEKDAY(A2)=3,A2,"")

regards,

Thank you that worked perfectly, is there a way to show the value of the specific Tuesday regardless of which day in the week it is and then once the week is finished it changes to the next Tuesday?

Thank you that worked perfectly, is there a way to show the value of the specific Tuesday regardless of which day in the week it is and then once the week is finished it changes to the next Tuesday?
Whose solution are you referring to?

If your week starts on Monday, use =TODAY()+2-WEEKDAY(TODAY(),2)
If your week starts on Sunday, use =TODAY()+3-WEEKDAY(TODAY(),1)

If your week starts on Monday, use =TODAY()+2-WEEKDAY(TODAY(),2)
If your week starts on Sunday, use =TODAY()+3-WEEKDAY(TODAY(),1)

Perfect,

Thanks again.

Glad to have been of help.

Replies
2
Views
67
Replies
10
Views
379
Replies
1
Views
269
Replies
7
Views
254
Replies
4
Views
156

1,203,241
Messages
6,054,320
Members
444,717
Latest member
melindanegron

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back