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