Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I shall try to explain!!!
I keep a record of certificate dates. These certificates are valid for six month only and have to be renewed every time. The certificate end date will always be at the end of the sixth month, but the start can be at any time at the first month. ie if I renewed on the 20th of Jan then the run out date will be 31 July. Now to complicate things. I can renew a certificate within 3 month of its expiry date the start date wil still be the same. ie with the same example...had I renewed within 3 month prior to the end of Jan, the expiry date will be the same (31 july). I hope that makes sense!! How can that be written in vb code? -- kk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Question | Excel Worksheet Functions | |||
Date question | Excel Worksheet Functions | |||
Date Question | Excel Discussion (Misc queries) | |||
Date Question | Excel Discussion (Misc queries) | |||
Another Date Question | Excel Discussion (Misc queries) |