Employee Attendance Tracker -

Question

Hi There,

I love this template so much that I desperately need to make few adjustments in order to get it customized for my company fiscal year.

1- Our week starts on Wed, so I was wondering how can I change it to start from Wed instead of Sunday. also I need the month to start on * June 2016 - May 2017 this is our fiscal year - 

2- I tried to have the S, S changed to M, T for our non working days following this example; 

=OR(H$8="Th", H$8="Fr", COUNTIF(lstHolidays, H9)>0)  so mine is M & T , The formula is 

=OR(H$8="M", H$8="T", COUNTIF(lstHolidays, H9)>0) if I do that that it gives me back " M, Tue, & Thu" in grey so I changed to 2 letter day M & Tu but it seems not to recognize the 2 letters day and only it dims Monday -

please help.

Thank you so much

Answer 1

This is a big (and complex) workbook and hence it would take time to solve your problem.

Currently I undergoing some medical treatment and hence not able to give sufficient time here on Microsoft Community.

However, we shall make an attempt to solve your problem step by step.

1. For your week to start on Wed, you have to manually change the Day in row-8

    Put "W" in cell H8, "Th" in cell I8, and so on till "Tu" in cell N8

    Now you can copy this range (H8:N8 to the remaining cells in that row

2. Now in conditional formatting, if you make the changes for "M" and "Tu" as your weekend,

    it would work.

3.  Regarding the year beginning June and ending in May,

     Since you are looking for the first month (in cell C9) to be June and then July in cell C10 (and so on)

     Pls  put the following formula in cell C9    =DATE($AN$5,6,1)

     and

     put the following formula in cell C10      =DATE(YEAR(C9),MONTH(C9)+1,1)  and drag till cell C20

     However, the impact of this last change on other cells in the workbook is yet to be studied (to check

     if it works as expected or whether it creates any problem in any other calculation).

For now - this is what is done. Will continue further on this and let you know.

Till then, if you want you too can try to work on it.

Hope you find this Helpful.

Answer 2

here is the excel file that i am working on;

https://1drv.ms/f/s!AqX\_vW3eJN\_-bLyp1qnIcrnVRbs

1- I need to have the week in cell H8 starts on Wed.

2- Non working days are Mon & Tue - when I use the formula =OR(H$8="M", H$8="T", COUNTIF(lstHolidays, H9)>0)  - it recognize Monday - Tuesday & Thursday since both Tue & Thu starts with T , but when I do Tu in the formula for tuesday =OR(H$8="M", H$8="TU", COUNTIF(lstHolidays, H9)>0)it does not recognize the day -

3- I want the fiscal year to starts in June and ends in May - 

Answer 3

Is it possible to share you .xlsx file  on OneDrive - so that we have a better understanding of your problem and accordingly try for some solution. 

If yes - then share the hyperlink of your file shared on OneDrive.

Answer 4

Hello there, the solution you provided only changed the calendar on my computer but not on the excel worksheet itself "employee attendance tracker " . Thanks for trying .

Answer 5

Have you tried changing the date setting under 'Region & Language' which falls under 'control panel' ?

If yes - did it help ?

If no - try the following :

Right Click on the start button and select "Control Panel"

CONTROL PANEL >> REGION and LANGUAGE >>