View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default counting down dates

Hi Masih,

Am Fri, 12 Oct 2012 09:38:36 +0000 schrieb Masih Ostad:

I want to write a formula for counting down dates from today.

Anyone who can help me, simplest possible? The date should be Swedish.
For example: 2012-10-30 (in this format).


your date in A1. Then try:
=A1-TODAY() and format the cell "General"


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2