Forum Discussion
LoraLewis
Jan 26, 2022Copper Contributor
How to freeze an excel calculation on a certain day
Background: At my place of work, we receive referrals for women who are pregnant. We have a master-list spreadsheet of all referrals we have ever had, and a separate weekly spreadsheet that only has ...
JKPieterse
Jan 26, 2022Silver Contributor
I would add a 'date referred' column to the sheet in which you just type today's date when you get
a new referral. Then use that new date in the gestational age calculation.
a new referral. Then use that new date in the gestational age calculation.