Thread: current date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bijan bijan is offline
external usenet poster
 
Posts: 44
Default current date

Hi All
I use Excel 2003 SP2 and have two question:
1. I try to set function "=year(date())" in control source property of a
textbox but I recive an error to use invalid property why?

2. I need get current date and minus 20 days and show it in a textbox with
this formt 04-JAN-2009?

Thanks in advance
Bijan