Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Understanding formula
What exactly does this formula do
=DATE(YEAR(O2)-1,1,1) I am trying to get it to print 2008 Any help appreciated Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Understanding formula
hi
the date formula has 3 parts. year, month and day in that order and is usually written... =date(year(a1),month(a1),day(a1)) to evaulate a date in A2 but it can be written =date(2008,7,3) which would be 7/3/08 the formula you posted... =DATE(YEAR(O2)-1,1,1) year(O2-1) subtracts 1 year form the date in O2 the puts month 1 and day1 so if O2 contained today date the formula would read 1/1/2007 if you just want to print the year, use this =year(O2) regards FSt1 "Dig" wrote: What exactly does this formula do =DATE(YEAR(O2)-1,1,1) I am trying to get it to print 2008 Any help appreciated Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NOT UNDERSTANDING THE FORMULA | Excel Worksheet Functions | |||
NOT UNDERSTANDING THE FORMULA | Excel Worksheet Functions | |||
Understanding a formula | Excel Worksheet Functions | |||
Understanding a formula | Excel Worksheet Functions | |||
Understanding this formula | Excel Worksheet Functions |