Dates
 

I have an excel document which has 12 sheets representing the months JAN-DEC,
and tracks admissions & discharges, length of stay, etc., of patients in our
facility. I need to calculate each sheet at the end of the month by
referencing in part the current date. Example: in JAN my calculations work
fine, until the date, =today(), changes to FEB 01, 2006... then the
calculations I made in JAN become useless.

Is there a way to Automatically create a fixed date for each Month to build
my calculations on, or am I going to have to just type a static date for the
end of each month?

Thanks in advance,
Randy

Dates
 

Hi

The formula below returns the date January, 1st 2006
=DATE(2006,1,1)

A1=DATE(2006,ROW(),1)
Format A1 in any valid date format (p.e. "yyyy.mm" or "yyyy mmmm"), and copy
it down - you get a list of (1st of) months starting from January 2006.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Jetlag5549" wrote in message
...
I have an excel document which has 12 sheets representing the months
JAN-DEC,
and tracks admissions & discharges, length of stay, etc., of patients in
our
facility. I need to calculate each sheet at the end of the month by
referencing in part the current date. Example: in JAN my calculations work
fine, until the date, =today(), changes to FEB 01, 2006... then the
calculations I made in JAN become useless.

Is there a way to Automatically create a fixed date for each Month to
build
my calculations on, or am I going to have to just type a static date for
the
end of each month?

Thanks in advance,
Randy

Dates
 

thank you,
:)

"Arvi Laanemets" wrote:

Hi

The formula below returns the date January, 1st 2006
=DATE(2006,1,1)

A1=DATE(2006,ROW(),1)
Format A1 in any valid date format (p.e. "yyyy.mm" or "yyyy mmmm"), and copy
it down - you get a list of (1st of) months starting from January 2006.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Jetlag5549" wrote in message
...
I have an excel document which has 12 sheets representing the months
JAN-DEC,
and tracks admissions & discharges, length of stay, etc., of patients in
our
facility. I need to calculate each sheet at the end of the month by
referencing in part the current date. Example: in JAN my calculations work
fine, until the date, =today(), changes to FEB 01, 2006... then the
calculations I made in JAN become useless.

Is there a way to Automatically create a fixed date for each Month to
build
my calculations on, or am I going to have to just type a static date for
the
end of each month?

Thanks in advance,
Randy