Excel formula help

[macz123]

Good Day Everyone is there any way i can link the cells below a cell that contains date. so that when i change the display week it will also change. here are some screenshots that will further explain my problem. Thank you.

[#2]

@macz123 

For example in cell B6 on the MINDSOFT sheet:

=IF(B$3=TODAY(),"'-cutting and bending of rebars
-chb fence","")

(There is a line break Alt+Enter after rebars)

Fill to the right to H3.

[#3]

Much the same as the reply from Hans. I hope you are able to read my screenshot.

@macz123 

[#4]

@macz123  alternatively you can use conditional formatting to make the text white and not visible

Assuming you only want the information in B5:H15 to show up if the Date in row 3 is today then:

conditional formatting -> custom formula -> =( B$3 <> TODAY() )

in the attached I did it for 'MINDSOFT' sheet 

[#5]

thank you for the help and idea. I really appreciate it. I use =IF(B$3=datevalue("date"),"'-cutting and bending of rebars
-chb fence","")