If you are using Microsoft's web interface at
http://www.microsoft.com/office/comm...g=en&cr=USeach thread is labelled with the date of the most recent message. If you usethe + button to expand the thread, the date of each message on the thread isshown.If you use a newsreader such as Outlook Express, the date would appear bydefault in the Sent column.--David Biddulph"Vijay Chary" wrote in ...... How do you find out how old any post is !? Vijay "MartinW" wrote: Couple of observations, 1 Your formula doesn't seem to work, =RAND(2) isn't correct syntax 2 Did you realise you replied to a 2 year old post?http://groups.google.com.au/group/microsoft.public.excel.worksheet.functions/browse_thread/thread/eca2b44b1463a48a/c8af7728a9ad196d?hl=en&lnk=st&q=how+can+i+set+up+r and+or+rand+between+#c8af7728a9ad196d Cheers Martin "Vijay Chary" wrote in message ... Answer: =(-1)^Int(Rand(2)+1) "Uesiet" wrote: i need a function to generate either 1 or -1 using randbetween inExce;