Count Number of Days after a Start Date

J

Jimbo

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.
 
B

Bernard Liengme

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
 
M

Mike H

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
 
D

Dave Peterson

=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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Date diffrence in days, weeks and months. 1
Populate row with work days 2
number of months and days between two dates without approximation 3
Calculate date so many days before/after current date. 4
How to change date format to 7 working days a week in ms project 2010? 0
=IF function with current date 3
Count the Number of Workdays 5

Top