The easiest way to understand it is to build it up in separate cells, step
by step, so you can see what values you get.

=TODAY() gives you today's date, so right now, 20/08/2006 (dd/mm/yyy)
=YEAR(TODAY()) gives you the year from today's date, so 2006
=DATE(YEAR(TODAY()),1,1) gives a date value using this year, month 1 and day
1, that is, 01/01/2006

If you were to format the cell as General or as Number you'd see that this
is 38718, the number of days since 01/01/1900

The numeric value for Today's date is 38949.

Hence you can use those values to calculate the number of days between two
dates, etc.

Regards

Trevor


"simserob" wrote in
message ...

btw, if you feel like it, i'd appreciate it if you explained what the
whole "DATE(YEAR(TODAY()),1,1)" is about, i don't really understand how
it's working and i just think it might help me in the future if i
understood the logic.

thanks again


--
simserob
------------------------------------------------------------------------
simserob's Profile:
http://www.excelforum.com/member.php...o&userid=36635
View this thread: http://www.excelforum.com/showthread...hreadid=573452