Search results

Dear Sir (The Doc Man) Thank you for trying to help me. No, It is not a question of displaying. In the attachment fig of 21-02-12 Figures 9 & 10, some date fields do not display any data, because these teachers have not taken any leave. So there is no question of rejoining again. Therefore...

No, what I want is conditional formatting to do the date fields. Some teachers take leave for exams weddings, Then are teachers who never take at all. So their fields like lef1, ret1, lef2, ret2 will have no data fill in these date fields. They will be blank. Therefore the final calculation...

Dear Pat Hartman, Thank you for expressing your view. I think after testing various ways to solve my problem in getting unrealistic values I think your idea might help me. So how can I use conditional formatting for my date fields if they do not have data? I think this might solve my problem...

Dear Sir, Thanks for the prompt reply. If you look at the attachments, you will see that there are blank date fields. When the dates are blank answers are either some unbelievable numbers like 123 or - 122. Whereas the answers are correct when date fields are filled. Please enlarge the...

Dear Sir, As I promised I did some testing. Your "NZ" proposal is some whar good. However, I get some unbelievable answers when date fields are blanks Pl see what you can do. I will try an attached all the connected docs See what you can do.. Thank you. Wilfred

Dear Sir, I was testing this NZ without knowing how to apply it. I test it and come back to you tomorrow. I a, about to go to sleep. Thank you very very much. Meet you tomorrow. Thank you again.

Dear Sirs/Madams, Dear all, I am Wilfred Cooray from Sri Lanka, I found this forum while searching for a forum to get simple answers to problems. Hope I will be able to help you also. My First problem with you is about Date calculation. The attachment is an Excel sheet that tries I am trying...

Ok I will do it.

Sorry, I tried this site does not allow the Excel file to be loaded I loaded a PDF file now. Wilfred.

Dear all, I am Wilfred Cooray from Sri Lanka, I found this forum while searching for a forum to get simple answers to problems. Hope I will be able to help you also. My First problem with you is about Date calculation. The attachment is an Excel sheet that tries I am trying to describe the...