ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional Statement (https://www.excelbanter.com/excel-worksheet-functions/150470-conditional-statement.html)

lbraddock

Conditional Statement
 
I have a spreadsheet with many different tabs at bottom, I want the 1st Tab
Vol Fee Schedule (Col E - Start Date) to go to the Fee Schedule (next tab)
and determine the first month I have activity for that particular project put
that month in mon-yr format, then, in the next column (Col F - Completion
Date) I want the Vol Fee Schedule to go to the Fee Schedule and tell me what
month the activity ends and put that month in mon-yr format. Then I want the
Column G (Duration Months) to calculate the number of months the project will
last. The information will be pulled from the next tab but entered on the
1st Tab.

I was able to get the Start Date to work okay, but I am having trouble with
the Completion Date and Duration of Months. Any help/suggestions would be
appreciated. LB





All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com