ExcelBanter - calculating back 4 years

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - calculating back 4 years (https://www.excelbanter.com/excel-worksheet-functions/131832-calculating-back-4-years.html)

Corey

calculating back 4 years

If I have sheet6.range("B1").value = format(now,"dddd dd mmmm yyyy")

and i want to have sheet6.range("B2").value to display B1- 4years, how can i do that?

Corey....

Toppers

calculating back 4 years

Try

Sheet6.Range("B2").Value = Format(DateSerial(Year(Now()) - 4, Month(Now()),
Day(Now())), "dddd dd mmmm yyyy")

HTH

"Corey" wrote:

If I have sheet6.range("B1").value = format(now,"dddd dd mmmm yyyy")

and i want to have sheet6.range("B2").value to display B1- 4years, how can i do that?

Corey...

All times are GMT +1. The time now is 05:53 AM.