Date formula

[Sahabo123]

I have been trying to calculate days. have four columns. Start date ,end date, days remaining and work days. To arrive at days remaining I subtract end date from start date but I keep on getting #value
Pls help mee

 

[MARK858]

Are you sure that both Start date and end date are both real dates and not text?
i.e. if you put

=ISNUMBER(A1)

in an empty cell (change A1 to your Start date cell) what do you get TRUE or FALSE? then change the A1 to your end date cell refererence and again what do you get TRUE or FALSE?

 

[Sahabo123]

start date is 8/9/2006 and the end date is 31/12/2006

 

[MARK858]

And the results of the =ISNUMBER tests were? especially for the end date.

 

[Sahabo123]

I'm lost ooh
Come down to my level beginners level pls

 

[MARK858]

Can't make it much easier in an empty cell put the formula =ISNUMBER(A1) changing the red A1 to what your cell reference is for start date and then do the same for end date.

You will get a result of TRUE or FALSE for each test.

Post what results you get back.