Finding Number of days!!!

  • Thread starter Thread starter admin
  • Start date Start date
A

admin

Can anyone help me!!!

I need to find the Total Number of days from a particular date to current
date.

for example: 02-09-2003 to 22-09-2003 = 20 days. which would help in
entering my data very easily. can anyone give me a formula or a solution
for this.

Thanks

Karan.
 
Hi Karan,

Format B2 as Date.
Put a pure date in B2.
Format B3 as Number (Yes, NUMBER)
Put the Formula '=Today()-B2' in B3

Warning:
Because no times are entered, they default to 12:00 AM.
Experiment with Short periods (eg - a date last week),
and modify the formula to add or subtract 1 to meet your
requirements.
Do not use Now(), since it includes the time since 12:00 AM,
unless you require fractional days.
--
Hope this helps!

Pat Garard
Australia.
apgarardATbigpondDOTnetDOTau
 
if for example, the first date is in cell A1 and the second date in cell A2,
just type =A2-A1 (format this cell as number)
 
Back
Top