Calculate Redemption Date
Aug 9, 2007
attached spreadsheet, columns A-E are given data, col B shows the redemption frequency, col C shows the advanced notice period and col E shows the our first investment date. I would like to display the result in one column showing the next redemption date..
e.g. for Fund 1, it's redemption term is quarterly 30 days notice, which means.. next redemption period will be 30/09/2007 (get money back) and we have to give the redmeption notice latest on 31 Aug 2007 becos of 30 days advance notice to exit the fund
e.g. for Fund 2, it's monthly 90 days notice, which means if we put in a redemption notice today then 90 days from now on will be 8 november, hence can get money back on 30 November 07.
What formula shall I use to display
- next available redemption date
- exit date (get money back)
View 9 Replies
ADVERTISEMENT
Mar 17, 2014
I have a file that tracks orders placed.
Column A gives the request date of the order, based on the TAT in column B the projected dispatch date gets calculated.
Once the order is dispatched and the date gets updated in column Z, the redemption status in column V gets updated as "Dispatched within TAT" or "Dispatched out of TAT" based on whether they have met the TAT or not. If the dispatch date is left blank then it shows "Yet to be dispatched".
My problem is that the column D does not stop calculation even after the order is dispatched. And therefore because of the conditional formatting turns red the minute the number is more than 0. So it is misleading.
View 3 Replies
View Related
Mar 9, 2014
I'm trying to workout how to take a known initial date a repeating frequency and work out the next due date from today.
Example
Initial Date :- 1st of January 2014
Frequency :- every 5 weeks
Current Date :- 9th of March 2014
Next Due date should be :-12th of March 2014 (if I worked it out correctly from my paper calendar)
I want to use a cell formula to do this for different initial dates and varying frequency periods (the frequency will always be whole weeks i.e. 1,2,3,4,5,6,7,8,8,10)
View 4 Replies
View Related
May 7, 2014
I needs a formula (not VBA) to calculate the required start date.
I have to do a job of 14 working hours and this job must be finished on 05-may-2014 13:00
My working week is from monday u/i friday and every day I work from 08:00-16:00
At what time do I have to start the job to get it done in time.
The formula should give this result: 01-may-2014 15:00
View 3 Replies
View Related
May 19, 2009
I need a formula that will calculate the number of days from a date entered into cell A1 to today's date. Whether it's before or after todays date. Example:
5/10/2009 to today is -9
5/22/2009 to today is 3
View 2 Replies
View Related
Apr 2, 2009
I have two columns of dates, leave start and end dates (when people start leave i.e. annual leave). Would need to introduce column(s) to calculate how many days fell within the month including the end date and excludes weekends.
For example, if the staff on leave from 31st March to 6 April, i need to show that the number of leave taken as 1 day in March and 4 days in April.
View 9 Replies
View Related
Jan 2, 2014
I have a table that looks like this (its basically a historical data of a stock exchange):
Date
Index
January 4, 2010
[Code]....
The List continues till the current Date.
I want to calculate Average Index Values of a Date of each month within a Date Range.
Example: Calculate Average Index Values for 3rd of Each month from 1st Feb 2010 to 3rd Jan 2011. Formula should calculate Average of the Index Values for 3rd Feb 2010, 3rd March 2010, 3rd April 2010, 3rd May 2010, 3rd June 2010, 3rd July 2010, 3rd Aug 2010, 3rd Sept 2010, 3rd Oct 2010, 3rd Nov 2010, 3rd Dec 2010, 3rd Jan 2011.
Both the Date and the Date Range is variable. Also, the Index Value for selected Date of one or more month may not be available as that being a holiday. In that case, the formula needs to use the last available Index Value before that Date. e.g. If Index Value for 3rd Oct 2010 is not available, system will use the Index Value of 2nd Oct 2010.
View 1 Replies
View Related
Sep 22, 2007
i am trying to create a forumla in a column (D in my expamle below) to count the number of days between two dates. Knowing that col D will change everytime the @now date changes - but thats ok..
COL A COL B COL D
ROW 1 Open Date Closed Date Count of days open
ROW 2 4/1/07 BLANK CELL Formula result here
ROW 3 4/1/07 9/5/07 Formula result here
if col b has a date then subrtract col a from b and display the # result, if col b is blank then subtract col a from location I store the @ now date - say Col ZZ Row 99? so no matter there is a count of number of days in every row in column D
View 3 Replies
View Related
May 13, 2008
I have column B with a heading "Days Remaining" and column L with a heading "Deadline". starting with row 5, I need to be able to enter a date in L5 and see the days I have left, from that day untill today, on B5. I need to then be able to enter a date into L6 and see a result in B6 and on and on. Then I need to be able to insert or delete a column and have the formulas still work in the columns with the heading "Days Remaining" and "Deadline"
View 7 Replies
View Related
Jun 12, 2014
Looking to calculate timecycle from open date to close date. Having trouble trying to figure out how to have the formula look at the close date cell and if it is blank go to the next cell in the row to find a close date and subtract the open date from the close date to get the total number of days in the timecycle. See attached example.
View 1 Replies
View Related
Jun 26, 2007
Take a look at the attachment file. Those highlighted in yellow are entered by the user. What is the formula to calculate the End date in (A6) after the user has entered the start date (A2) & the number of weeks (A4)?
View 5 Replies
View Related
Jan 25, 2010
I have a start date for a contract in cell AM1. I need AN1 show a date six months from the start date in AM1. I am fine with that part.
However, I would like for AN1 to calculate not only a six-month date but also to auto-update to the next six month date from AM1 once the first six month date is about, let's say, one month past. What I am doing is calculating when a six-month inspection needs to be completed; these inspections are ongoing, so I need them to auto-update.
So let's say a contract was awarded today, 25 JAN 2010. That would be value in AM1.
I want AN1 to produce a date six months from 25 JAN 2010, which would be 25 JUL 2010 (yes, this way of calculating the six month date is fine). Then around, let's say, 25 AUG 2010, I want AN1 to auto-update to produce the next six month date, which would be 25 JAN 2011 (six months from 25 JUL). Obviously the function would need to relate to TODAY() in some way.
View 11 Replies
View Related
May 13, 2014
I have a date and need to formula to tell me the date of the Sunday that occurs before it.
For example I want to it tell me that the Sunday before 13/05/2014 is 11/05/2014.
View 5 Replies
View Related
Jan 18, 2007
What is the formula to calculate a due date from a date in another cell?
If the date is 06-12-06 and the due date is the end of the month six months later, 12-31-06, how do I do this?
View 10 Replies
View Related
Nov 22, 2013
I want to calculate the end date of my German courses. This is how it works:
A course consists of 60 LU*. The course can occur i. e. three times a week: Monday, Wednesday and Friday. In each day the course lasts 2 LU, which means 6 LU each week. There is no course on Tuesday, Thursday, Saturday, Sunday and on holidays. Therefore this type of course that begins on 18-Nov-2013 will end on 03-Feb-2014.
Another course which occurs Tuesday, Thursday and Saturday, and respectively has 2 LU on Tuesday, 2 LU on Thursday and 3 LU on Saturday and starts on 03-Dec-2013 will end on 06-Feb-2014.
Therefore I want to create a worksheet where I set the start date, choose the days and respectively the LU amount on those days. The end date shall be calculated according to these criteria.
The workday function on excel cannot do this and I do not have any programming skills to work with VBA.
Legend:
*LU = lesson units; 1 LU is 45 minutes
Holidays:
28-Nov-13
29-Nov-13
08-Dec-13
09-Dec-13
25-Dec-13
31-Dec-13
01-Jan-14
[Code] ...........
View 7 Replies
View Related
Feb 23, 2009
Is there a formula for calculating date for every 2nd thursday of the month excluding holidays?
View 4 Replies
View Related
Jul 3, 2012
I have a file that has filled me with dot '.' instead of bar '/'.
Would be possible to calculate dates in this format?
Data Firts
Date Last
Result
02.05.2012
03.05.2012
1
would then be a day as 'A2' - 'B2' = 1
View 6 Replies
View Related
Jul 30, 2008
how to calculate the date for one year. If i have 24-Jun-08 (A1) i need to calculate 24-Jun-09. If i do =A1+365 it gives me an error (the little green thing in the corner of the box) is there a way to do this without the error showing up.
View 9 Replies
View Related
Jul 3, 2014
I'm looking for a formula that will subtract a specific # of days from a future date, and then if the answer is a weekend, go to the next business day.
For example, I want to subtract 84 days from a deadline. Let's say the deadline is in cell A4, and is 1/3/15. I want to subtract 84 days from A4. This brings me to 10/11/14 which is a Saturday. I need the date produced to be the following Monday, 10/13/14.
View 3 Replies
View Related
Jan 16, 2009
Attached is the sheet I want to find the start date which shall be the end date (predecessor task end date) + 1 day in column c when I define predecessor in Column E which is the task number from Column A
View 2 Replies
View Related
Apr 20, 2009
I request a help:
A1 = 01-Apr-2009
B1 = 02-Apr-2009
C1 = 03-Apr-2009
D1 = Blank
E1 = 05-Apr-2009
F1 = 06-Apr-2009
What is the best suitable formula to find "First blank cell", then "date difference" between today and its previous cell's (i.e today minus "C1" in this case).
View 12 Replies
View Related
Apr 30, 2009
I have weeks in format YY-WW (this week is 09-18) and wish to calculate the full date for the week commencing day for that week. '09-18 is in cell S8. To work out the date I currently have: =DATE(LEFT(S8,2),1,RIGHT(S8,2)*7-8)-WEEKDAY(DATE(LEFT(S8,2),1,3))
Which I thought was working fine, but turns out to be the WC date for 1909. I'll probably have to change the -8, that's not a problem, but I can't work out how to get it to 2009.
View 3 Replies
View Related
Jul 16, 2013
The sheet have Added date (when is the data was added) , updated On (when was the data updated) , name I want to calculate when how many days was it delayed.. how can I do it
View 2 Replies
View Related
Jun 12, 2014
1) In column A, I have different effective dates.
2) Based on Current system date, I want B column to be populated as "Overdue Date, or Due today or, Due tomorrow or Future dated" in front of that date.
View 5 Replies
View Related
Nov 18, 2006
I am having great difficulties getting the following formula to calulate wether the date in cell f2 is greather than of less than the given date.
=IF(F2<="18.11.06", "No Cover", "Under Warranty")
f2 = 14.09.02
This does produce the wanted result of "No cover" however if the date is 14.09.07 and therefore greater the 18.11.06 i will not get the expected result of "Under Warranty"
View 14 Replies
View Related
Oct 28, 2008
I have a sheet with dates in this format: 20080910. 1st: I tried to change the date format & tried most of formats but wasn't able to change it to become something like this: 05/22/08. Then what I need is to create a formula to calculate how many years till today has passed since that day.
View 5 Replies
View Related
Feb 25, 2014
I need a formula to give a result if one date is earlier than another.
The cells G and H both contain dates set up as month and year only.
I'm trying to create a formula as follows:
If the date in H is before the date in G to give a result of "Check".
View 1 Replies
View Related
Jan 29, 2008
Im trying to calculate a date in excel.
A2 = 28.01.2008
A1 should provide the date from A2 minus 1 weekday. (so 25.01.2008)
View 9 Replies
View Related
Mar 14, 2008
I made to automatically calculating by date which is time formating want to count the stem hours, but it prompted error?
Sub UpdateColG()
Dim IRow As Long
For IRow = 3 To Range("F").End(xlUp).Row
Range("G" & IRow).Value = Range("F" & IRow).Value - Range("F" & IRow - 1).Value
Next
End Sub
===================================
the logical is Range (F2-F1) returns to (G2)
sample : (F2)10:30-(F1)09:45 =(G2)00:45.
View 9 Replies
View Related
Apr 2, 2009
I would like a macro to calculate the number of days for a date if cell has date. For example If cell A has a date cell B should automatically do the calculation for =TODAY()-A1
Cell ACell B
3/21/09Calculation from Macro
3/22/09Calculation from Macro
3/26/09Calculation from Macro
View 9 Replies
View Related
