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
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
