Often it happens that people at home or office want to know whether a person would be on duty or off duty for planning a work or a function at home etc.
This software has been developed using Visual basic for applications (VBA) and runs in MS-Excel. Macros will have to be enabled for the file for this software to work.The software takes two inputs:-
(a) The date when the person has joined the shift ( to be entered in B1 cell)
(b) The date when his availability is to be ascertained. (to be entered in B4 cell)
After entering this data, click anywhere on the sheet, the result will be displayed in B7 cell and the full shift schedule starting from the date he has joined the shift to the test date period would be available in cell A10 onwards. Presently this will work for people in 14 days on/off shift.
click_here to download the file! Please note that macros have to be made enabled in order for this to work.