Count Number of Days after a Start Date
 

I need a formula to calculate the number of days from a start date.

In cell A1 I have the date 5/6/2009, when I open the spreadsheet 3 days from
now I want to display the number 3 in cell B1. Is this something you would
use with NETWORKDAYS?

I would appreciate your help.
--
Jim

Answer: Count Number of Days after a Start Date
 

Hi Jim,

Yes, you can use the NETWORKDAYS function to calculate the number of days between a start date and today's date. Here's how you can do it:

1. In cell B1, enter the following formula:
   Code:

   ---

   =NETWORKDAYS(A1,TODAY())

   ---

2. Press Enter to calculate the number of working days between the start date in cell A1 and today's date.
   
3. The result will be displayed in cell B1 as the number of days between the start date and today's date.

Note that the NETWORKDAYS function excludes weekends and any dates that you specify as holidays. If you want to include weekends, you can use the DATEDIF function instead. Here's how:

1. In cell B1, enter the following formula:
   Code:

   ---

   =DATEDIF(A1,TODAY(),"d")

   ---

2. Press Enter to calculate the number of days between the start date in cell A1 and today's date.
   
3. The result will be displayed in cell B1 as the number of days between the start date and today's date, including weekends.

Count Number of Days after a Start Date
 

=TODAY()-A1


"Jimbo" wrote in message
...
I need a formula to calculate the number of days from a start date.

In cell A1 I have the date 5/6/2009, when I open the spreadsheet 3 days
from
now I want to display the number 3 in cell B1. Is this something you
would
use with NETWORKDAYS?

I would appreciate your help.
--
Jim

Count Number of Days after a Start Date
 

Assuming there are no holidays, this will work =NETWORKDAYS(A1,TODAY())
See Help to learn how to allow for holidays

I assume you want workdays. =TODAY() - A1 will give total days
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Jimbo" wrote in message
...
I need a formula to calculate the number of days from a start date.

In cell A1 I have the date 5/6/2009, when I open the spreadsheet 3 days
from
now I want to display the number 3 in cell B1. Is this something you
would
use with NETWORKDAYS?

I would appreciate your help.
--
Jim

Count Number of Days after a Start Date
 

Hi,

It's what networkdays was designed for

=NETWORKDAYS(A1,TODAY(),Holidays)

Holidays is a named range of holiday dates and can be ommited.

Mike

"Jimbo" wrote:

I need a formula to calculate the number of days from a start date.

In cell A1 I have the date 5/6/2009, when I open the spreadsheet 3 days from
now I want to display the number 3 in cell B1. Is this something you would
use with NETWORKDAYS?

I would appreciate your help.
--
Jim

Count Number of Days after a Start Date
 

=today()-A1
and format as general.

This is just doing a subtraction, so weekends will be included.

(To excel dates are just numbers that are nicely formatted.)

Jimbo wrote:

I need a formula to calculate the number of days from a start date.

In cell A1 I have the date 5/6/2009, when I open the spreadsheet 3 days from
now I want to display the number 3 in cell B1. Is this something you would
use with NETWORKDAYS?

I would appreciate your help.
--
Jim

--

Dave Peterson