calculating back 4 years

  • Thread starter Thread starter Corey
  • Start date Start date
C

Corey

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....
 
Try

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

HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add years NOT days 3
use dates to create a summary report 1
Scrabble Value calculation for Welsh words 0
Unhide roes in a different worksheet - My code is not working 3
Receiving 'Error 1004' with VBA program 1
calculating service dates 2
Run Time Error for Vlookup & Match command 1
Complex date VBA - insert a certain weekday 5

Back
Top