Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem of calculating years months and days | Excel Discussion (Misc queries) | |||
FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL DATE | Excel Discussion (Misc queries) | |||
calculating years/months with YEARFRAC? | Excel Worksheet Functions | |||
calculating the years | Excel Worksheet Functions | |||
Calculating deviation from mean and % change for varying years | Excel Discussion (Misc queries) |