Hi,
I am working on a sheet that has some special formulas that use a date column for calculation. The date must be the first of the given month for the calculation to work properly. The sales folks are not completing the sheet properly which is causing a lot of manual corrections/calculations.
2 questions
1) Is there a way that I can have a default value in a date cell so the calculation will always work? For example, it would automatically have 1/1/2008 if they didn't put anything into the cell? Some of the folks are not putting a date in which causes the formula to go haywire and not roll up properly giving me "value" error message.
2) Is there a way that could force a date to be typed in that is the first day of a given month? So if they typed 1/15/2009, it would change to 1/1/2009?
Thanks as always for any help you can offer.
Bugs
I am working on a sheet that has some special formulas that use a date column for calculation. The date must be the first of the given month for the calculation to work properly. The sales folks are not completing the sheet properly which is causing a lot of manual corrections/calculations.
2 questions
1) Is there a way that I can have a default value in a date cell so the calculation will always work? For example, it would automatically have 1/1/2008 if they didn't put anything into the cell? Some of the folks are not putting a date in which causes the formula to go haywire and not roll up properly giving me "value" error message.
2) Is there a way that could force a date to be typed in that is the first day of a given month? So if they typed 1/15/2009, it would change to 1/1/2009?
Thanks as always for any help you can offer.
Bugs