the DATE formula was probably used as OP wanted to add 6 months. so using misrasomendra's formula:
some other considerations for your range as misrasomendra pointed out:
3 ways:
1. go to your data, click on a single cell or to be safe, the whole range (like A1:J47) & press CTRL + T to convert it to a Table. now anything added will be in part of the Table & part of your pivot
2. use formula OFFSET, put it in your Named Range & rename the source data to this Named Range
3. use formula INDEX & put it in your Named Range & rename the source data to this Named Range
for 2 & 3, you can start a thread separately.
another tip. we are merely guessing what you are trying to achieve. so instead of showing us your formula which didn't work, let us know what you are trying to do with the criteria. for eg.
column b must be equals to "C/C"
column G must be equals to 2
etc
Bookmarks