In my worksheet, I recently started using this function =IF(A2<>"",TODAY(),"")
Basically whenever a value in A2 is entered. B2 gives me a date. I dragged down the function in my column so it can be automatic.
The problem now is, My excel function to calculate profit =SUM(IF(MONTH(B15:B9000)=A1,H15:H9000)) is returning a #VALUE
A1 is January aka 1 to represent the first month.
Any help on how to get around this issue will be greatly appreciated. Thank you.
Bookmarks