Date troubles

[kulmjord]

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.

 

[Tetra201]

Is this what you need (3 is for Tuesday)?

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

 

[RickXL]

Hi,

You could try something like this:

Excel 2013
	A	B
1	Date	Label
2	01/12/2016
3	02/12/2016
4	03/12/2016
5	04/12/2016
6	05/12/2016
7	06/12/2016	Tue 06/12/2016
8	07/12/2016
9	08/12/2016
10	09/12/2016
11	10/12/2016
12	11/12/2016
13	12/12/2016
14	13/12/2016	Tue 13/12/2016
Sheet1

Cell Formulas
Range	Formula
B2	=IF(WEEKDAY(A2)=3,A2,"")

regards,

 

[kulmjord]

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?

 

[Tetra201]

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?

 

[kulmjord]

Whose solution are you referring to?

Your solution,

Thanks.

 

[Tetra201]

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

 

[kulmjord]

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.

 

[Tetra201]

Glad to have been of help.