The return in cell A1 should read the sum of six different cells. These cells
will be identified by a time period over the last six months from today
now()
What strategy (or formula) should I use to make this happen?

What I am looking at is to count the number of days absent in the last six
months of an employee, recorded in separate months.