Substract days from a date

[josros6074]

I have a date field link to another sheet,

so what I want to do is:

for example cell e2 on "Outstanding cheques" sheet link to cell e3 on "Cdn. HSBC" sheet,

that formula I am looking for is: on e2 =if( cell E3 on "Cdn. HSBC" sheet, Month has 31 days, then month-6 days, otherwise Month-5 days)

so I always want the cell to Display for ej. April 25, 2013, May 25, 2013, always display the 25 of the month.

Thank you

[ChemistB]

How about
=DATE(YEAR('Cdn. HSBC'!E3), MONTH('Cdn. HSBC'!E3), 25)

[josros6074]

Solved, thank you.

[Jonmo1]

Another way..

='Cdn. HSBC'!E3-DAY('Cdn. HSBC'!E3)+25