Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VACCRUED VACATION / DISPLAYED
I AM TRYING TO DISPLAY THE CURRENT MONTH OF ACCRUED VACATION.
EXAMPLE: ACCRUED VACATION TIME 01/01/08 02/01/08 21.32 02/01/08 03/01/08 22.15 03/01/08 04/01/08 22.98 04/01/08 05/01/08 23.82 05/01/08 06/01/08 24.65 i HAVE CREATED A SUMMARY TAB WICH SHOULD DISPLAY THE CURRENT ACCRUED VACATION TIME FOR A SPECIFIC EMPLOYEE. I'M LOOKING FOR A FORMULA TO USE. THAT WILL ALWAYS DISPLAY THE ACCRUED VACATION TIME IN REFERENCE TO TOAYS DATE. SHOULD I USE AN =IF STATEMENT. EXAMPLE: =IF(C33)TODAY() THIS IS AS FAR AS i AM GETTING AT THE MOMENT. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VACCRUED VACATION / DISPLAYED
I don't understand what you are trying to do, but if you post back
with some further explanation please make use of the CAPS LOCK to avoid typing only in upper case - it is difficult to read and considered to be the equivalent of shouting (i.e. rude). Pete On Feb 4, 5:59*pm, HELP ME!!! <HELP wrote: I AM TRYING TO DISPLAY THE CURRENT MONTH OF ACCRUED VACATION. EXAMPLE: * * * * * * * * * * * * * * * * * ACCRUED VACATION TIME 01/01/08 * * * *02/01/08 * * *21.32 02/01/08 * * * *03/01/08 * * *22.15 03/01/08 * * * *04/01/08 * * *22.98 04/01/08 * * * *05/01/08 * * *23.82 05/01/08 * * * *06/01/08 * * *24.65 i HAVE CREATED A SUMMARY TAB WICH SHOULD DISPLAY THE CURRENT ACCRUED VACATION TIME FOR A SPECIFIC EMPLOYEE. I'M LOOKING FOR A FORMULA TO USE. THAT WILL ALWAYS DISPLAY THE ACCRUED VACATION TIME IN REFERENCE TO TOAYS DATE. SHOULD I USE AN =IF STATEMENT. EXAMPLE: =IF(C33)TODAY() THIS IS AS FAR AS i AM GETTING AT THE MOMENT. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VACCRUED VACATION / DISPLAYED
To calculate the total accrued vacation from one date to another:
=((EndDate-StartDate)*AccuralPerDay)-AnyUsedVacation To calculate the total accrued vacation from a point in history to today: =((today()-StartDate)*AccuralPerDay)=AnyUsedVacation Vaya con Dios, Chuck, CABGx3 "HELP ME!!!" wrote: I AM TRYING TO DISPLAY THE CURRENT MONTH OF ACCRUED VACATION. EXAMPLE: ACCRUED VACATION TIME 01/01/08 02/01/08 21.32 02/01/08 03/01/08 22.15 03/01/08 04/01/08 22.98 04/01/08 05/01/08 23.82 05/01/08 06/01/08 24.65 i HAVE CREATED A SUMMARY TAB WICH SHOULD DISPLAY THE CURRENT ACCRUED VACATION TIME FOR A SPECIFIC EMPLOYEE. I'M LOOKING FOR A FORMULA TO USE. THAT WILL ALWAYS DISPLAY THE ACCRUED VACATION TIME IN REFERENCE TO TOAYS DATE. SHOULD I USE AN =IF STATEMENT. EXAMPLE: =IF(C33)TODAY() THIS IS AS FAR AS i AM GETTING AT THE MOMENT. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VACCRUED VACATION / DISPLAYED
Please do not enter your messages in capitals. It is considered to be
yelling. Also it makes your message difficult to read. Assuming your start dates are in A1:A5, your end dates are in B1:B5 and your hours are in C1:C5 then use this: =SUMPRODUCT((TODAY()=B1:B5)*C1:C5) Tyro "HELP ME!!!" <HELP wrote in message ... I AM TRYING TO DISPLAY THE CURRENT MONTH OF ACCRUED VACATION. EXAMPLE: ACCRUED VACATION TIME 01/01/08 02/01/08 21.32 02/01/08 03/01/08 22.15 03/01/08 04/01/08 22.98 04/01/08 05/01/08 23.82 05/01/08 06/01/08 24.65 i HAVE CREATED A SUMMARY TAB WICH SHOULD DISPLAY THE CURRENT ACCRUED VACATION TIME FOR A SPECIFIC EMPLOYEE. I'M LOOKING FOR A FORMULA TO USE. THAT WILL ALWAYS DISPLAY THE ACCRUED VACATION TIME IN REFERENCE TO TOAYS DATE. SHOULD I USE AN =IF STATEMENT. EXAMPLE: =IF(C33)TODAY() THIS IS AS FAR AS i AM GETTING AT THE MOMENT. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
VACCRUED VACATION / DISPLAYED
Sorry for the yelling ;o).
ACCRUED VACATION TIME 01/01/08 02/01/08 21.32 02/01/08 03/01/08 22.15 03/01/08 04/01/08 22.98 04/01/08 05/01/08 23.82 05/01/08 06/01/08 24.65 Since todays date is 02/04/08 the value that will be display in my summary sheet will be 22.15 of accrued vacation. But if todays date was to be 03/02/08 the 22.98 accrued value would be displayed. I'm not looking for exact accrued vacation time but an on going month to month total of how much vacation time employees are accruing on a month - month basic. Let me know if this is enough info. Thanks for the help. "Pete_UK" wrote: I don't understand what you are trying to do, but if you post back with some further explanation please make use of the CAPS LOCK to avoid typing only in upper case - it is difficult to read and considered to be the equivalent of shouting (i.e. rude). Pete On Feb 4, 5:59 pm, HELP ME!!! <HELP wrote: I AM TRYING TO DISPLAY THE CURRENT MONTH OF ACCRUED VACATION. EXAMPLE: ACCRUED VACATION TIME 01/01/08 02/01/08 21.32 02/01/08 03/01/08 22.15 03/01/08 04/01/08 22.98 04/01/08 05/01/08 23.82 05/01/08 06/01/08 24.65 i HAVE CREATED A SUMMARY TAB WICH SHOULD DISPLAY THE CURRENT ACCRUED VACATION TIME FOR A SPECIFIC EMPLOYEE. I'M LOOKING FOR A FORMULA TO USE. THAT WILL ALWAYS DISPLAY THE ACCRUED VACATION TIME IN REFERENCE TO TOAYS DATE. SHOULD I USE AN =IF STATEMENT. EXAMPLE: =IF(C33)TODAY() THIS IS AS FAR AS i AM GETTING AT THE MOMENT. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
VACCRUED VACATION / DISPLAYED
Now that you have explained what you really need. Assuming your start
dates are in A1:A5, your end dates are in B1:B5 and your hours are in C1:C5 then use this: =VLOOKUP(TODAY(),A1:C5,3) Tyro "HELP ME!!!" <HELP wrote in message ... I AM TRYING TO DISPLAY THE CURRENT MONTH OF ACCRUED VACATION. EXAMPLE: ACCRUED VACATION TIME 01/01/08 02/01/08 21.32 02/01/08 03/01/08 22.15 03/01/08 04/01/08 22.98 04/01/08 05/01/08 23.82 05/01/08 06/01/08 24.65 i HAVE CREATED A SUMMARY TAB WICH SHOULD DISPLAY THE CURRENT ACCRUED VACATION TIME FOR A SPECIFIC EMPLOYEE. I'M LOOKING FOR A FORMULA TO USE. THAT WILL ALWAYS DISPLAY THE ACCRUED VACATION TIME IN REFERENCE TO TOAYS DATE. SHOULD I USE AN =IF STATEMENT. EXAMPLE: =IF(C33)TODAY() THIS IS AS FAR AS i AM GETTING AT THE MOMENT. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
VACCRUED VACATION / DISPLAYED
I tried this but no luck.
EXAMPLE: start mo. end of month ACCRUED VACATION TIME in days 01/01/08 02/01/08 21.32 02/01/08 03/01/08 22.15 03/01/08 04/01/08 22.98 04/01/08 05/01/08 23.82 05/01/08 06/01/08 24.65 If todays date was 03/02/08 then excel would just display 22.98 If todays date was 04/02/08 then excel would just display 23.82 No other calculation needed. I have already calculated whats needed. I just want excel to automatically use todays date to determine what value will be displayed in a given cell. "Tyro" wrote: Please do not enter your messages in capitals. It is considered to be yelling. Also it makes your message difficult to read. Assuming your start dates are in A1:A5, your end dates are in B1:B5 and your hours are in C1:C5 then use this: =SUMPRODUCT((TODAY()=B1:B5)*C1:C5) Tyro "HELP ME!!!" <HELP wrote in message ... I AM TRYING TO DISPLAY THE CURRENT MONTH OF ACCRUED VACATION. EXAMPLE: ACCRUED VACATION TIME 01/01/08 02/01/08 21.32 02/01/08 03/01/08 22.15 03/01/08 04/01/08 22.98 04/01/08 05/01/08 23.82 05/01/08 06/01/08 24.65 i HAVE CREATED A SUMMARY TAB WICH SHOULD DISPLAY THE CURRENT ACCRUED VACATION TIME FOR A SPECIFIC EMPLOYEE. I'M LOOKING FOR A FORMULA TO USE. THAT WILL ALWAYS DISPLAY THE ACCRUED VACATION TIME IN REFERENCE TO TOAYS DATE. SHOULD I USE AN =IF STATEMENT. EXAMPLE: =IF(C33)TODAY() THIS IS AS FAR AS i AM GETTING AT THE MOMENT. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
VACCRUED VACATION / DISPLAYED
Where is the three coming from???
It looks like we're on the right track but excel isn't recognizing this formula. I'm assuming I'm doing something wrong. "Tyro" wrote: Now that you have explained what you really need. Assuming your start dates are in A1:A5, your end dates are in B1:B5 and your hours are in C1:C5 then use this: =VLOOKUP(TODAY(),A1:C5,3) Tyro "HELP ME!!!" <HELP wrote in message ... I AM TRYING TO DISPLAY THE CURRENT MONTH OF ACCRUED VACATION. EXAMPLE: ACCRUED VACATION TIME 01/01/08 02/01/08 21.32 02/01/08 03/01/08 22.15 03/01/08 04/01/08 22.98 04/01/08 05/01/08 23.82 05/01/08 06/01/08 24.65 i HAVE CREATED A SUMMARY TAB WICH SHOULD DISPLAY THE CURRENT ACCRUED VACATION TIME FOR A SPECIFIC EMPLOYEE. I'M LOOKING FOR A FORMULA TO USE. THAT WILL ALWAYS DISPLAY THE ACCRUED VACATION TIME IN REFERENCE TO TOAYS DATE. SHOULD I USE AN =IF STATEMENT. EXAMPLE: =IF(C33)TODAY() THIS IS AS FAR AS i AM GETTING AT THE MOMENT. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
VACCRUED VACATION / DISPLAYED
The 3 means column 3 - in this case columnn C. Did you enter the formula as
=VLOOKUP(TODAY(),A1:C5,3) ? That formula says lookup today's date in column A for an exact match or for the largest date that is less than today's date and return the corresponding value from column C. So, if today's date is 2/4/2008, the formula would return 22.15 Tyro "HELP ME!!!" wrote in message ... Where is the three coming from??? It looks like we're on the right track but excel isn't recognizing this formula. I'm assuming I'm doing something wrong. "Tyro" wrote: Now that you have explained what you really need. Assuming your start dates are in A1:A5, your end dates are in B1:B5 and your hours are in C1:C5 then use this: =VLOOKUP(TODAY(),A1:C5,3) Tyro "HELP ME!!!" <HELP wrote in message ... I AM TRYING TO DISPLAY THE CURRENT MONTH OF ACCRUED VACATION. EXAMPLE: ACCRUED VACATION TIME 01/01/08 02/01/08 21.32 02/01/08 03/01/08 22.15 03/01/08 04/01/08 22.98 04/01/08 05/01/08 23.82 05/01/08 06/01/08 24.65 i HAVE CREATED A SUMMARY TAB WICH SHOULD DISPLAY THE CURRENT ACCRUED VACATION TIME FOR A SPECIFIC EMPLOYEE. I'M LOOKING FOR A FORMULA TO USE. THAT WILL ALWAYS DISPLAY THE ACCRUED VACATION TIME IN REFERENCE TO TOAYS DATE. SHOULD I USE AN =IF STATEMENT. EXAMPLE: =IF(C33)TODAY() THIS IS AS FAR AS i AM GETTING AT THE MOMENT. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
VACCRUED VACATION / DISPLAYED
Yes, I typed it exactly but nothing happens???
"Tyro" wrote: The 3 means column 3 - in this case columnn C. Did you enter the formula as =VLOOKUP(TODAY(),A1:C5,3) ? That formula says lookup today's date in column A for an exact match or for the largest date that is less than today's date and return the corresponding value from column C. So, if today's date is 2/4/2008, the formula would return 22.15 Tyro "HELP ME!!!" wrote in message ... Where is the three coming from??? It looks like we're on the right track but excel isn't recognizing this formula. I'm assuming I'm doing something wrong. "Tyro" wrote: Now that you have explained what you really need. Assuming your start dates are in A1:A5, your end dates are in B1:B5 and your hours are in C1:C5 then use this: =VLOOKUP(TODAY(),A1:C5,3) Tyro "HELP ME!!!" <HELP wrote in message ... I AM TRYING TO DISPLAY THE CURRENT MONTH OF ACCRUED VACATION. EXAMPLE: ACCRUED VACATION TIME 01/01/08 02/01/08 21.32 02/01/08 03/01/08 22.15 03/01/08 04/01/08 22.98 04/01/08 05/01/08 23.82 05/01/08 06/01/08 24.65 i HAVE CREATED A SUMMARY TAB WICH SHOULD DISPLAY THE CURRENT ACCRUED VACATION TIME FOR A SPECIFIC EMPLOYEE. I'M LOOKING FOR A FORMULA TO USE. THAT WILL ALWAYS DISPLAY THE ACCRUED VACATION TIME IN REFERENCE TO TOAYS DATE. SHOULD I USE AN =IF STATEMENT. EXAMPLE: =IF(C33)TODAY() THIS IS AS FAR AS i AM GETTING AT THE MOMENT. |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
VACCRUED VACATION / DISPLAYED
Is the cell where you put the formula formatted as text? If so, format the
cell as general, select the cell, press F2 and press Enter. Are you in manual calculation mode? If so change to automatic. I tested the formula and it works fine. Tyro "HELP ME!!!" wrote in message ... Yes, I typed it exactly but nothing happens??? |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
VACCRUED VACATION / DISPLAYED
The cell was already formatted as general.
How to I check if I'm in auto calculation mode??? "Tyro" wrote: Is the cell where you put the formula formatted as text? If so, format the cell as general, select the cell, press F2 and press Enter. Are you in manual calculation mode? If so change to automatic. I tested the formula and it works fine. Tyro "HELP ME!!!" wrote in message ... Yes, I typed it exactly but nothing happens??? |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
VACCRUED VACATION / DISPLAYED
I don't know what version of Excel you're using. Prior to Excel 2007,
Tools/Options From there, you'll have to look for it. But I have Excel 2007 where it's Office Button - Excel Options - Formulas - Workbook calculation. You can press Shift+F9 to force recalculation of the active worksheet. Tyro "HELP ME!!!" wrote in message ... The cell was already formatted as general. How to I check if I'm in auto calculation mode??? "Tyro" wrote: Is the cell where you put the formula formatted as text? If so, format the cell as general, select the cell, press F2 and press Enter. Are you in manual calculation mode? If so change to automatic. I tested the formula and it works fine. Tyro "HELP ME!!!" wrote in message ... Yes, I typed it exactly but nothing happens??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vacation with accural | Setting up and Configuration of Excel | |||
vacation schedule | Charts and Charting in Excel | |||
Vacation planner | Excel Discussion (Misc queries) | |||
Vacation Pay Calculation | Excel Discussion (Misc queries) | |||
Vacation | Excel Worksheet Functions |