Thread: calculating back 4 years
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Corey Corey is offline
external usenet poster
  
Posts: 172
Default 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....
Reply With QuoteReply With Quote