periods

I am trying to place a period after a middle initial and after a title. =A1&"." works however some don't have a middle initial or the name is spelled out so I do not want a period there. Any help with this would be very much appreciated! Column A Column B Column C Column D Mr...

Hello All, I have a dataset that runs from 01-11-16 to 31-03-18 from D4:D519. One Row for each day of the year. I also have a table of data which has each day broken down into 48 Half Hour periods per day. I am trying to find out in each month what the total cost is in these half hour periods...

Hi, I'm trying to show historical drawn down (not only the max draw down but each time there is a draw down) of return series, and for each of the drawn down to capture # of periods from Peak to Trough and # or periods to recovery. Draw Down is defined as % decline from previous peak. in the...

I am trying to create a formula that I can insert into a 'start period' cell and drag to populate % changes (different for each period). What is the best function to utilize for this purpose? (See Below) <tbody> Using the "Starts" Table, calculate total fees for each project, fee amounts...

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody> 3) Using the "Starts" Table, calculate total fees for each project, fee amounts generated each period per project, and total fees. Assumptions: The fee is...

Hi Everyone, I am running into a frustrating problem with a VBA project I am working on. Our organization uses a 14 month year (12 regular months and 2 special posting periods for trailing charges), and I am not sure how to handle the two extra periods. I want to validate that the month of the...

Hi all At my work we have some different billing codes, each specifying an amount of money the client should pay. The billing codes are as following: Billing code 012: Week days 08.00-17.00 Billing code 013: Week days 17.00-08.00 Billing code 014: Weekends (SATURDAYS) Billing code 015...