Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Formulae in Excel
|
|
|
Bookmark this page|
The UK's most regular 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. |
Formulae in Excel
Resolved · High Priority · Version 2003
Reply
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
For upcoming training course dates see: Pricing & availability
RE: Formulae in Excel
Hi MickThank 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
|
 |
|
» Forum post: Presentation and animation. more information |
How do you animate aart and objects
