98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulae in Excel
Formulae in Excel
Resolved · High Priority · Version 2003
Wed 24 Jun 2009, 15:54Delegate Mick said...
Mick has attended:
Excel Advanced course
Formulae in Excel
When creating a spreadsheet in Excel and using the EDATE formula. I have to leave all the cells with the default date of 31/01/1900 and enter a new start date in each respective row.
Is there a way of hiding the contents of these cells until a new start date is netered in the next row.
What I am trying to do is create a spread sheet to automatically generate the next date at 3,6,9,and 12 month intervals after entering the new start date. Please can someone offer any advice
Thu 25 Jun 2009, 09:54Trainer Stephen said...
RE: Formulae in Excel
Hi Mick
Thank you for your question
If I follow you correctly, you have a block of cells,each row comprising a date followed by 4 edate functions. Unused rows are set to 31/01/1900 and this date replaced when the row is used.
If this is the case then the simplest solution is to conditionally format the table so that any cells with the value 31/01/1900 have a white font colour. This would then hide them and make the values appear when a new date is typed in.
If i have misunderstood your problem, please do not hesitate to get back to me
Regards
Stephen
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Reset Excel toolbars to default settingsIf you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults. |
