I am creating a sheet that has a front/master sheet into which my colleagues
enter information on a daily basis, I then want that information to feed
through to further sheets. However the front sheet is always sety to Today()
and I want the further info to feed into the correct dates on the back up
sheets. I have tried setting up IF formuale but it just keeps coming up
#VALUE.

HELP!!!!