how do we get the date count? I'm aware that this you could use this
05/05/05 - 01/05/05= 4days

*BUT* i need to work out the date to count on day one e.g 01/05/05
including weekend so i tried this 05/05/05 -01/05/05+1=5, works well
but im hoping +1 can be avoid. I have tried WEEKDAY function but only
count in the week apart from weekend.

Secondly, the information I required to work but i can't seem to get it
to work (sorry can't seem to get the attachment) :-

(In column A1) 01/04/2005 (date start from)
(In column A2) 31/03/2006 (date end)


(In column E1) 04/07/2005
(In column F1) 00/01/1900
(In column G1) 04/07/2005

(In column G1 =E1+F1)
(In column H1 =IF(OR(G1<A1,G1<A2),"X","Y")

If no date has been input or 00/01/1900, it will come up an "X", how do
we stop this, only for when a date is input?


Lastly, i have been given by another register user, DAV, this is to
enable me that if a date is input then it will show date and if a
letter or word is typed then it will leave a blank
=if(isnumber(a1),a1,"")format as a date),

And yes this does work, , i have changed at the last part to 0 and
this is what i wanted.


=if(isnumber(a1),a1,0)

So want to say *THANKS* to DAV;)

Craig


--
craig@help
------------------------------------------------------------------------
craig@help's Profile: http://www.excelforum.com/member.php...o&userid=36201
View this thread: http://www.excelforum.com/showthread...hreadid=561816

On Sun, 16 Jul 2006 04:14:01 -0400, craig@help
wrote:


how do we get the date count? I'm aware that this you could use this
05/05/05 - 01/05/05= 4days

*BUT* i need to work out the date to count on day one e.g 01/05/05
including weekend so i tried this 05/05/05 -01/05/05+1=5, works well
but im hoping +1 can be avoid. I have tried WEEKDAY function but only
count in the week apart from weekend.

=EndDate - StartDate + 1

You will need the +1.



Secondly, the information I required to work but i can't seem to get it
to work (sorry can't seem to get the attachment) :-

That's good. Better to not post attachments. Many will not download them.


(In column A1) 01/04/2005 (date start from)
(In column A2) 31/03/2006 (date end)


(In column E1) 04/07/2005
(In column F1) 00/01/1900
(In column G1) 04/07/2005

(In column G1 =E1+F1)
(In column H1 =IF(OR(G1<A1,G1<A2),"X","Y")

If no date has been input or 00/01/1900, it will come up an "X", how do
we stop this, only for when a date is input?


=IF(OR(A1="",A2="",E1="",F1="",F1=0),"",IF(OR(G1<A 1,G1<A2),"X","Y"))


--ron

Ron Rosenfeld Wrote:
On Sun, 16 Jul 2006 04:14:01 -0400, craig@help
wrote:


how do we get the date count? I'm aware that this you could use this
05/05/05 - 01/05/05= 4days

*BUT* i need to work out the date to count on day one e.g 01/05/05
including weekend so i tried this 05/05/05 -01/05/05+1=5, works well
but im hoping +1 can be avoid. I have tried WEEKDAY function but only
count in the week apart from weekend.

=EndDate - StartDate + 1

You will need the +1.



Secondly, the information I required to work but i can't seem to get
it
to work (sorry can't seem to get the attachment) :-

That's good. Better to not post attachments. Many will not download
them.


(In column A1) 01/04/2005 (date start from)
(In column A2) 31/03/2006 (date end)


(In column E1) 04/07/2005
(In column F1) 00/01/1900
(In column G1) 04/07/2005

(In column G1 =E1+F1)
(In column H1 =IF(OR(G1<A1,G1<A2),"X","Y")

If no date has been input or 00/01/1900, it will come up an "X", how
do
we stop this, only for when a date is input?


=IF(OR(A1="",A2="",E1="",F1="",F1=0),"",IF(OR(G1<A 1,G1<A2),"X","Y"))


--ron

Many thanks for this, and worked pretty good.

Craig;)


--
craig@help
------------------------------------------------------------------------
craig@help's Profile: http://www.excelforum.com/member.php...o&userid=36201
View this thread: http://www.excelforum.com/showthread...hreadid=561816