Date matter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ShamsulZ - 04 Oct 2006 09:28 GMT

Say cell A1 the date is '01/09/2006' and i want to know how many days there
are to 30/09/2006. i try '=30/09/2006-A1' but it not working. pls help with
the correct formula. thanks friends

Reply to this Message

Roger Govier - 04 Oct 2006 09:46 GMT

Hi

Either use
=DATE(2006,9,30)-A1
or
=--"30/09/2006"-A1
the double unary minus -- forces the text value to be a date value.

Signature

Regards

Roger Govier

> Say cell A1 the date is '01/09/2006' and i want to know how many days
> there
> are to 30/09/2006. i try '=30/09/2006-A1' but it not working. pls help
> with
> the correct formula. thanks friends

Reply to this Message

Jaleel - 04 Oct 2006 09:52 GMT

Hi,

Put 30/09/2006 in Cell A2. Put the formula =A2-A1+1 in Cell A3 and format
the cell as number.

Regards,

Jaleel

> Say cell A1 the date is '01/09/2006' and i want to know how many days there
> are to 30/09/2006. i try '=30/09/2006-A1' but it not working. pls help with
> the correct formula. thanks friends

Reply to this Message

Stefi - 04 Oct 2006 09:53 GMT

=DATEDIF(A1,DATE(2006,10,30),"d")
Regards,
Stefi

„ShamsulZ” ezt írta:

> Say cell A1 the date is '01/09/2006' and i want to know how many days there
> are to 30/09/2006. i try '=30/09/2006-A1' but it not working. pls help with
> the correct formula. thanks friends

Reply to this Message

Max - 04 Oct 2006 09:54 GMT

One way ..
Assuming A1 houses a real date,
Try it in B1 as: = --"30/09/2006"-A1
Format B1 as general or number

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Say cell A1 the date is '01/09/2006' and i want to know how many days there
> are to 30/09/2006. i try '=30/09/2006-A1' but it not working. pls help with
> the correct formula. thanks friends

Reply to this Message