Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
|||
|
|||
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:
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:
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating number of days including the start and end date | Excel Discussion (Misc queries) | |||
Calculating number of days including the start and end date | Excel Discussion (Misc queries) | |||
count a number of days from a date | Excel Discussion (Misc queries) | |||
I want to count days between two dates including start date | Excel Worksheet Functions | |||
How do I count the number of days from 1 date to another? | Excel Discussion (Misc queries) |