Question about dates/times

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brendan - 07 Nov 2007 02:34 GMT

Is there an efficient way to format columns for the date, time, and day of
week, and then reference that data in statements, for example using an if
statement assume a certian value for each month/day of week/time of day?

Reply to this Message

Bob Phillips - 07 Nov 2007 03:22 GMT

That is a very ambiguous question.

Firstly, it is simple to format a column, just select the column, and use
Format>Cells>Date and Time and choose a format.

But what does '... an if statement assume a certain value for each month/day
of week/time of day...' mean?

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Is there an efficient way to format columns for the date, time, and day of
> week, and then reference that data in statements, for example using an if
> statement assume a certian value for each month/day of week/time of day?

Reply to this Message

JE McGimpsey - 07 Nov 2007 03:23 GMT

First - the way a cell is formatted doesn't affect the underlying value,
which is what other cells will use in calculations. So how the IF()
statement interprets the value doesn't depend at all on how the cell is
formatted.

One way:

A1: <date>

Format as "dddd dd mmm yyyy hh:mm:ss"

What "certain value" do you want to assume?

You can use

=MONTH(A1)
=WEEKDAY(A1)

or for time,

=MOD(A1,1)

Reply to this Message