Dates

[Jetlag5549]

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

 

[Arvi Laanemets]

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.

 

[Jetlag5549]

thank you,

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.