Attendance policy --help with formula

tracymaz

New Member
Joined
Mar 27, 2019
Messages
1
HI!

We have a 12 month rolling attendance points policy. I have all of the formulas figured out except for we allow employees to earn points back by having perfect attendance for 30 days from their last occurance. Trying to figure out how I can add a column and formula in to automatically calculate. Any suggestions would be greatly appreciated. New to the forum...not sure how to attach the excel spreadsheet for view.
Thanks!
Tracy
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
4,177
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
you can't attach files on this forum but can share them on Google drive, One drive etc
 

Watch MrExcel Video

Forum statistics

Threads
1,109,158
Messages
5,527,137
Members
409,749
Latest member
esmarques

This Week's Hot Topics

Top