Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to write a formula to help me build a salary phasing schedule. I
want to be able to change a persons start date and reclaculate the full year expense. For instance, a person make 120K per year at 10K per month and I have jan - dec in columuns. If they start jan 1 the exp for jan is 10K, feb 10K mar 10K etc. etc. I want to be able to change hte start date to feb 1 and see jan at 0, feb at 10K, mar 10K etc. etc. Can you help? Thanks. |