### Tags: calculate, calculating, event, excel, insert-function-day360, microsoft, msdn, proble, remaining, software

# Calculating days until an event

On Microsoft » Microsoft Excel

2,424 words with 2 Comments; publish: Fri, 23 May 2008 06:18:00 GMT; (30646.88, « »)

My question is...Is there a way for Excel to calculate the remaining days

until an event? I got as far as (Insert-Function-Day360) My only proble

is...is I need one date to be the current date. and the other to be what ever

date is found in the adjacent column.

For example...I need the spreadsheet to show me how many days are left

until I need to send out a notice to our clients. and I would like it to

update each day I open it. I am pretty sure you have to run a macro but I am

not sure how to do that. Can anyone help me

*http://excel.todaysummary.com/q_microsoft-excel_40783.html*

All Comments

Leave a comment...

- 2 Comments
- Hi
use dATEDIF in combination with TODAY(). See:

http://www.cpearson.com/excel/datedif.htm

--

Regards

Frank Kabel

Frankfurt, Germany

"Silvababie" <Silvababie.excel.todaysummary.com.discussions.microsoft.com> schrieb im

Newsbeitrag news:9A766F39-6511-46A6-9A60-BC35C5A4DD31.excel.todaysummary.com.microsoft.com...

> My question is...Is there a way for Excel to calculate the remaining

days

> until an event? I got as far as (Insert-Function-Day360) My only

proble

> is...is I need one date to be the current date. and the other to be

what ever

> date is found in the adjacent column.

> For example...I need the spreadsheet to show me how many days are

left

> until I need to send out a notice to our clients. and I would like

it to

> update each day I open it. I am pretty sure you have to run a macro

but I am

> not sure how to do that. Can anyone help me

#1; Fri, 23 May 2008 06:19:00 GMT

- Hi
- On Fri, 12 Nov 2004 06:20:05 -0800, "Silvababie"
<Silvababie.excel.todaysummary.com.discussions.microsoft.com> wrote:

>My question is...Is there a way for Excel to calculate the remaining days

>until an event? I got as far as (Insert-Function-Day360) My only proble

>is...is I need one date to be the current date. and the other to be what ever

>date is found in the adjacent column.

>For example...I need the spreadsheet to show me how many days are left

>until I need to send out a notice to our clients. and I would like it to

>update each day I open it. I am pretty sure you have to run a macro but I am

>not sure how to do that. Can anyone help me

Assume the date of the event is stored in A1.

The number of days until that date can be represented by the formula:

=A1-TODAY()

Format the cell as General.

--ron

#2; Fri, 23 May 2008 06:20:00 GMT

- On Fri, 12 Nov 2004 06:20:05 -0800, "Silvababie"