View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sebation Sebation is offline
external usenet poster
 
Posts: 5
Default how to get the random date between the start date and the end date?

hi,
how can get the random date if i give a start date(2007-01-01) to the end
date(2010-12-31)?futher,how can i achieve that the random date is not the
first date of month or the end date of month.
i.e start date 01-01-2007 end date 12-31-2007 i want get 02-01-2007 or
02-29-2008

can anybody give me a guide?

regards,
sebation