date in cell driven from Worksheet name

[Johny_0342]

so have a work sheet where i have a date being driven from the Tab name of a worksheet, this give me what i want in one cell.

now i need it to take that cell and in another cell have 6 days deducted.

2018-04-19 13_26_28-Commercial Indirects - Project Time Registration.xlsx [Read-Only] - Excel.png

so in week commencing i would like the date in week ending - 6 days.

if possible

keep getting issues with the week ending cell being formulae driven

[samba_ravi]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[JohnTopley]

Try

for "Week Commencing"

=SUBSTITUTE(A1,".","/")-6

A1 contains your "Week ending" Date so change formula as required

[Johny_0342]

works great thanks

[Phuocam]

Try this:

=SUBSTITUTE(REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),""),".","/")-6