Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need help with correct formula to take a starting date from one cell and
place a formula in another cell that will increase the number by one for every 365 days. Employment date 5/30/2010 - 365 days past, new cell shows value "1" representing 1 year Another year passes and the new cell automatically updates to show the value "2" representing 2 years employment Another 365 days pass I need the value of the cell to automatically increase to "3" I tried the IF functions with TODAY() function but don't quite have it solved correctly. Thanks for your help if you will please... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Numbering Sheets incrementally (as in Invoice numbers) | New Users to Excel | |||
Numbering Sheets incrementally (as in Invoice numbers) | Excel Worksheet Functions | |||
Numbering Sheets incrementally (as in Invoice numbers) | Excel Discussion (Misc queries) | |||
How do I copy and paste cells incrementally? | Excel Worksheet Functions | |||
List incrementally? | Excel Worksheet Functions |