Calculate absence in a period

**jsmity** · 04-28-2009, 08:49 AM

Hi,
Can you tell me how i would calculate the number of sickness days and occaisions in the previous 26 week period from todays date.

I've attached the spreadsheet.

So in C4 i want to have the total number of times(occasions) the person has been absent in the previous 26 weeks.

and in E4 i want to have the Total number of Days (taken from E7:E20) the person has been sick in the past 26 weeks

**NBVC** · 04-28-2009, 08:55 AM

In C4:

=COUNTIF(C7:C20,">="&TODAY()-182)

in E4

=SUMIF(C7:C20,">="&TODAY()-182,E7:E20)

where 182 = 26 weeks * 7 days/wk

**jsmity** · 04-28-2009, 09:01 AM

thanks very much

**soji3357** · 09-07-2011, 04:55 PM

Hi am a complete novice but can anyone help with a very basic formula. I need to create a spreadsheet (basic) to show when an employee has hit 3 periods of absence and anoyther one to show when they hit 2 periods. any help will be gratefully appreciated. Thans

**NBVC** · 09-07-2011, 05:11 PM

Welcome to the forum,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.