Posted to microsoft.public.excel.worksheet.functions

Dig

external usenet poster

Posts: 17

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
NOT UNDERSTANDING THE FORMULA	PAPABEAR2252	Excel Worksheet Functions	1	September 12th 05 05:37 PM
NOT UNDERSTANDING THE FORMULA	PAPABEAR2252	Excel Worksheet Functions	3	September 10th 05 10:45 PM
Understanding a formula	Jordan	Excel Worksheet Functions	1	May 27th 05 05:42 AM
Understanding a formula	Jordan	Excel Worksheet Functions	6	May 26th 05 09:14 PM
Understanding this formula	Sal	Excel Worksheet Functions	4	March 26th 05 06:32 PM

All times are GMT +1. The time now is 01:56 PM.

About Us

"It's about Microsoft Excel"