I am having a dreadful time trying to get a value using data from one sheet to a total in another sheet.
There are "load dates", and i need to count the total number of load dates at the end of a month, however, if the dates are for example 15-jan, 15-jan, 16-jan then i need the count to return a value of 2, not count every single date.
How can i do this? i have tried everything i can think of.....
There are "load dates", and i need to count the total number of load dates at the end of a month, however, if the dates are for example 15-jan, 15-jan, 16-jan then i need the count to return a value of 2, not count every single date.
How can i do this? i have tried everything i can think of.....