Hide Zero and Date adding

H

Harold

Hi,
I have two questions both of which you have probably seen 1000 tim
but here goes

1. I have a statistical worksheet that will have data added during th
year as it comes available, I want to set it up so all total formula
etc are in place but I dont want it to count or display all the zero
for the rest of the year. Is there a way to not count all the zero
(hence thinking that week has happened) until you enter the data fo
the whole worksheet.

2. is it possible for excell to work out the amount of days betwee
two date fields i.e. field 1 =(2 July 2004) field 2 (20 july 2004) = 1
days. I already have the feilds setup as dates.

Thankyo
 
F

Frank Kabel

Hi
1. just use a formula like
=IF(A1="","",your_formula)

2.
Simply use the formula
=B1-A1
and format the resulting cell as 'Number'
 
O

otium

1. I assume that you have a week number or some such thing against the
entries. If so I would suggest you set up a new cell where you enter
the week that you want to add to - i.e. current week. For the totals
you can now use the COUNTIF function.

2. Just subtract one date from the other - Excel stores dates as
numbers relative from a point in time.
 
Top