Hi

Try
=TEXT((A1-WEEKDAY(A1)+2),"dd/mm/yy")& " - "
&TEXT((A1-WEEKDAY(A1))+6,"dd/mm/yy")

--

Regards
Roger Govier

"happysak" wrote in message
...
I need to automatically add to a header the dates of the week (Monday
through
Friday) that the current date falls in. For example, today is 12/04/2007.
I
want the header to also show that this week is 12/03/07-12/07/07. Any
help?
Thanks
--
happysak