We are going to use a default of today for the date field. The FedEx web page expects it in the form of “DayMonthYear”, and digits with only one number require a leading zero. The string returned fromlocaltime( )gives us the correct day, and we strip off the last two digits of ...
So a Concrete Example: D17 has currently a value of 2, because through the function (=COUNTIF(D1:D12;"*"&INDIRECT(ADDRESS(ROW();1))&"*") ), it found on array D1:D12 the value "bb" twice. What I'd actually want, would be that everytime the value "bb" is found, it mult...
The FedEx web page expects it in the form of "DayMonthYear", and digits with only one number require a leading zero. The string returned from localtime( ) gives us the correct day, and we strip off the last two digits of the year. For the month we need to translate it to a ...