Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Exclamation counting down dates

Hi
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).

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting Dates Daoud Fakhry Excel Discussion (Misc queries) 3 July 15th 07 02:44 PM
counting dates Tim Rowlan Excel Worksheet Functions 5 August 31st 06 07:59 PM
counting occasions dates occur between 2 dates hoyt New Users to Excel 5 June 16th 06 08:11 AM
Counting dates, within a list of dates jrheinschm Excel Worksheet Functions 7 April 19th 06 06:13 PM
Counting Dates? Aviator Excel Discussion (Misc queries) 3 January 10th 05 08:05 PM


All times are GMT +1. The time now is 03:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"