Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35
Default 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
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,104
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
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
Calculating number of days including the start and end date Terri Excel Discussion (Misc queries) 2 March 2nd 09 02:18 PM
Calculating number of days including the start and end date Shane Devenshire[_2_] Excel Discussion (Misc queries) 0 February 26th 09 11:45 PM
count a number of days from a date RGlade Excel Discussion (Misc queries) 3 December 4th 08 07:36 PM
I want to count days between two dates including start date Infinitebiscuit Excel Worksheet Functions 2 February 20th 07 01:27 PM
How do I count the number of days from 1 date to another? Steve R Excel Discussion (Misc queries) 3 February 2nd 06 09:58 PM


All times are GMT +1. The time now is 07:06 PM.

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"