I am doing someone bookkeeping for someone on Excel. On some minor receipts, she insists on entering several in one line. How do I put a date range in the spreadsheet (ie June - December 2011) so that the year will be picked up in a formula result elsewhere on the page? Thanks in advance for your help.
This is the formula: =IF(YEAR($A821)=2011,$I821,0).
Bookmarks