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

Populate row with work days 1
Count days between text dates 8
Count until condition is met and then retain final count 2
Pls help to find number of days for ageing report 3
Count the Number of Workdays 5
Calculating number of days including the start and end date 1
Excel Date Count 2
Formula for finding Date difference between 2 dates 4

Top