View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chad[_3_] Chad[_3_] is offline
external usenet poster
 
Posts: 32
Default Need a date range

Hi All,

I am trying to store todays date minus x amount of days. So I get todays
date with Date Function, format it to YYMMDD. Now my problem is, today is
the 12, so if I minus 2 weeks I get 80999, not 080929. So it drops my
leading zero and ignores the month

How do I maintain a date structure across month changes.

Thanks
Chad