In the attached spreadsheet example, is there a way to:
Reference the month and day ONLY of Clmn A:
Then have it auto create a sum formula . . .
I put the days of the year across (had to delect some clmns due upload size. . .), and at the end of that range per row, I need:
The next clmn to be SUM of Jan-1 to day before Date of Hire.
then
The next clmn to be Sum of Date of Hire to Dec-31.
This is so confusing to manually select like I did in the example.
Is there a way to get this to automatically select the range based on the date? (And then these sums will be referenced in another clmn as well. . .)
Any brave souls out there to try this?
I would really appreciate it!!!
Thank You!
- Daphne
Bookmarks