ExcelBanter - counting down dates

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - counting down dates (https://www.excelbanter.com/new-users-excel/447364-counting-down-dates.html)

Masih Ostad

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.

Claus Busch

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

All times are GMT +1. The time now is 01:36 PM.