Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating a Value every 15th and 1st
I am trying to track my vacation time, which accrues at the rate of six hours
every two weeks. I know this has got to be possible, but I have no clue. I'm starting with the figure "61" in a cell. I would like to have 6 added to that figure every two weeks. Any suggestions? Thanks! -A |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating a Value every 15th and 1st
Your title and body are in slight contradiction. Do you gain 6 hrs every 2
weeks, or on the 1st & 15th? (former results in 6*26, latter is 6*24) Assuming the former: In A2, place start amount. In A3, input start date. To calculate current hours: =A2+6*INT((TODAY()-A3)/14) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Hugnuffer" wrote: I am trying to track my vacation time, which accrues at the rate of six hours every two weeks. I know this has got to be possible, but I have no clue. I'm starting with the figure "61" in a cell. I would like to have 6 added to that figure every two weeks. Any suggestions? Thanks! -A |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting for 15th and last day of the month | Excel Worksheet Functions | |||
Problem with date - can't enter 15th! | Excel Worksheet Functions | |||
Date if before or after 15th of month | Excel Worksheet Functions | |||
15th of prior month | Excel Worksheet Functions | |||
Set the serial number every 15th column | Excel Discussion (Misc queries) |