I can sum spreadsheet values based on the dates entering them manually like this. Dates are in column B and dollar values in column N.
I have issues trying it like with date variables: week7_start, week7_end. I don't get anything summed doing it this way.
I have tried using Clng & CDate but it doesn't seem to matter. What am I missing?
Here's what the output looks like on my spreadheet.
Week Start Date End Date
Week 7 $(93.31) 8-Feb 14-Feb Manual dates
Week 7 $- 8-Feb 14-Feb Variable dates