Programming dates
I'm not sure I understand your question but if the value is a date say you
call it bday then bday + 7 would be 7 days later or bday - 30 would be 30 days earlier. I don't know if that helps at all. David "jenna" wrote: I have a table column A to colimn E of data, this is what i have in mind First see if A15=A16 and B15=B16, if yes created two variable; bdate and adate, bdate will be 30days before c15 which contains date whiles a date is 30 after C15, compare this to c16, if c16 is between bdate or adate then go to F16 and enter e16. If any of the above is false, go to the next row and repeat the prcess. Any help is appreciated thanks |
All times are GMT +1. The time now is 02:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com