Formula to calculate number of days & ignore blank cells

M

Mifty

Hi there,

I've set up a spreadsheet for someone else that calculates the number of
days worked by temporary employees. When I initially set it up, I thought I
just needed a column for start dates and a column for end dates, but the
person I have set it up for also wants a number of dates worked up to now
column.

I'm very new to this so realise that the way I have done it is probably
quite clumsy.

My original formula in C (days worked) was
=IF(OR(ISBLANK(A1),(ISBLANK(B1))),"",(B1-A1)) where A=start date and b=end
date. I used isblank so that C would remain empty if A and B were blank.

My problem is how do I amend this formula so that if I added an extra column
(today's date) C(days worked) would say stay blank if A is empty if B(end
date) is empty calculate number of days worked so far but if B(end date) has
a date then calculate how many day worked altogether.

Hope this isn't total gobbledygook.

Many thanks
Mifty
 
M

Mifty

Hi Anne,

Will try tomorrow and let you know.

Thanks for taking the time to answer
Cheers
 
M

Mifty

Lovely thank you :)

Now all I need is a way to calculate the difference between the two dates
that counts the 1st and last day

Any ideas? or should I start a new thread

Cheers
 
M

Mifty

Hi there daddylonglegs,

tried that but get a 1 in cell C if A is blank. Any way around this?
 
D

daddylonglegs

If A1 is truly blank you can only get a blank using that formula

Are you using the formula exactly as I posted it or have you modified
it?

...or does A1 have something in it - perhaps 0?
 
M

Mifty

My mistake!!!!
Sorry it works perefectly
Many thanks to Daddylonglegs and Anne
Cheers
 
Top