# Calculating Future Day And Date

Nov 24, 2012

I think I may have over engineered this formula.

\$F\$40 = Cell with Event Date

=IF(WEEKDAY(\$F\$40,2)

ADVERTISEMENT

## Calculating Age In Future Using EXCEL?

Jul 1, 2014

I am trying to find a formula which will show the date of a potential student on a certain date e.g 1st August 2014

Cell A2 has the students date of birth

Cell B2 has the students current age

I would like cell C2 to show the students date of birth on the 1st August 2014.

## Compute The FuTure Date When Start Date,Lead Date,Weekly Offs,Leaves And Holidays

Nov 15, 2008

First and foremost I would like to congragulate you on this wondeful piece of code in the below link...

The query was to get a future date excluding Fridays and Holidays...

http://www.excelforum.com/excel-work...rkingdays.html

I have a similar query and therefore I pasted this link...

I actually wanted to get a future date using a Dynamic two day off as my the offs keep on changing as well as incorporate Holidays and Leaves if any..

Now Holidays would be official Public Holidays and
Leaves would be taken by the employee..

The code needs to pick the Leaves + Holidays and different offs maybe even more than 2 offs...

## Date Countdown: Results Of The Number Of Days Between Today And A Future Date

Apr 8, 2009

I am trying to get the results of the number of days between today and a future date. I am using ="cell containing futuredate"-today() and it gets me the correct number of days. The problem comes in when I have yet to populate the future dates. I am getting -39991 (numeric value between today and jan 01 01) and because I am also using conditional formatting this is even more of a problem. Is there a way get excel to display nothing if it is a negative number? or to give a specified resut if the number becomes negative such as Expired or something of that nature?

## Add Future Date To Cell

Aug 2, 2006

I want to have a future date (30 days from today’s date) added to a cell in column A only if that cell is already blank and column N has an “O” in that same row. Here is the code that I have right now, and it works to add a value based on the conditions that I just described. I just don’t know how to get it to add a date to that is 30 days in advance of today’s date.

If Me.Cells(.Row, "N").Value = "O" And Me.Cells(.Row, "A").Value = "" Then
Me.Cells(.Row, "A").Value = "1"
End If

## Disable Program At A Future Date?

Dec 6, 2012

I am working as a private consultant for a company, and have put together a series of Excel applications, producing charts and providing some statistical guidelines. I will move on from here soon, and will take my work with me. I want to leave this product with the company, but it will become obsolete without some formula maintenance. Therefore, I would like to be able to have the program basically stop working at a future date. I don't really care if it freezes up, deletes itself or implodes. If not I am also afraid many copies of this program will be made and sent to others in my small community.

## How To Calculate Date In The Future And Subtract One Day

Nov 9, 2011

I'm trying to calculate a date in the future and subtract one day.

The date entered in N38 is 11/09/11.

The term entered in months in C8 is 24.

I want N39 to return the date 24 months in the future minus one day.

So N39 should dispay 11/08/13

How the heck do I do that?

## Automatically Calculate Date In The Future

Jul 25, 2007

I am trying to create a spreadsheet that will automatically calculate a date in the future.

The future date calculated needs to take the time NOW (as the user completes a field) and determines if this is before MIDNIGHT on the following SUNDAY. If so it calculates the date as a Tuesday 2 weeks on. For example... I request a date now on 1st Jan which is a Thursday. This is before midnight Sunday and so the date calculated would be Tuesday 20th January.

If the time NOW is after MIDNIGHT Sunday and before the next TUESDAY.. ie 0001hrs on the Monday and 2359hrs on the Monday then the date returned should be Tuesday 3 weeks on.. e.g 27th.

It would also need a function that would allow the total number of referrals on a Tuesday to 20 at which point it would overspill and provide a date on the Friday of the same week.. so in the first example it would be Friday 23rd

Is this something that can be achieved with formulas and a set of dates for it to calculate from or do I need to find someone who can do it in VBA for me.

## Input Future Date And Time Into One Cell

Oct 20, 2012

I need to input a future date and time into one cell. For example, if I have a member ship that ends on October 20th at 3:00 pm exactly the kind of format you get when you enter the function "NOW". I would like to put that into one cell and then be able to add and subtract from it.

For example I would like to do something like this, if I had inputed the date and time in A1:

"=Now-A1", it would be cool if I can get the remaining hours or minutes along with how many days are left but not completely needed.

It would also be beneficial if I can drill down further and do it by time zone as well.

## How To Change Row Color Depending On Future Date

Dec 31, 2013

I have some real estate rental so what I did 7 columns and its includes: name, phone number, ....., contract start date, and contract expiry date.

my question is how to make the row color changes depends on the expiry date

for example, the expiry date is 12/10/2014. I want the the row to be red when 12/10/2014 comes.

## OR Or IF Adding: Display A Date 3 Months In Future?

Nov 19, 2009

Three columns.

A - Date last checked
B - Due Date
C - Actual Date checked

Currently column B simply has =A+84 and will display a date 3 months in future.. Great..

However now i want column B to still display the 3 month date - unless there is a date in C, whereby i want B to then display OK. SO what im sort of needing is =A+84 (or if somethings in C then "OK")

## How To Translate Number Of Months Into Future Date

Dec 9, 2009

I've developed a spreadsheet in Excel 2000 where one of the cells contains the number of months a quantity will last, calculated by taking the total amount and dividing it by the amount used each month (a constant).

I would like to have another cell where that number is translated into the future date that number of months represents, so that in addition to seeing how many months the total amount will last, one can see when the amount will be depleted.

For example, suppose it is December 9, 2009 (as it is now) and the number in the number-of-months cell is 6. Then, is there a way that when 6 is calculated, in another cell appears something like June 9 2010 or 6/9/2010 or 6/9/10 (assuming the computer's clock is correct)?

It would be nice if the formula would handle decimals too, such as the date for 6.4 months, but that's not essential.

## Function To Automatically Insert Future Date

Mar 14, 2013

I need to create a spreadsheet which will have a start date and duration on programme. Is there any way I am able to automatically insert the End dates based on the weeks on the programme?

Additionally, can a function insert a date for the reviews which should be every two weeks into seperate cells?

Name
start date
weeks on programme
End date
1st review

[Code]...

## Calculate Future Date Excluding Weekends

Aug 25, 2007

I am using the same structure to update another column, under the same sub:

If Target.Column = 5 Then '

Select Case Range("d69").Value
Case "CB1W"
ActiveCell.Value = DateAdd("ww", 1, Now())
Case "CB2W"
ActiveCell.Value = DateAdd("ww", 2, Now())
Case "CB3W"
ActiveCell.Value = DateAdd("d", 21, Now())
Case "CB4W"
ActiveCell.Value = DateAdd("d", 28, Now())
Case "CB5W"
ActiveCell.Value = DateAdd("d", 35, Now())
Case "NI"
ActiveCell.Value = ""
Case Else
ActiveCell.Value = ""
End Select

I would like to apply the code to the whole column but if I change Select Case Range("d69").Value to Select Case Range("d2:1000").Value I get a Type Mismatch Error (13) - (on Case "CB1W" ) - column d cells are data validation drop down boxes that get their value form a named ranged :Lead_Status. The column is also formatted as Text. (I applied the code to d69 because I have data already in the other cells which I don't want altered till I have the code working)

I would also greatly appreciate your advice on how to incorporate the WEEKDAY function to exclude weekends for the DateAdd function.

## Calculate Future Date But Omit Weekends

Dec 27, 2007

I want to calculate a date that is 28 days in the future. I don't want to exclude any days - However - if the end date falls on a weekend or holiday, I would like to push it out to the next business day.

I currently have the weekends covered, but am stumped on the holidays.

(For weekends, I am using the WEEKDAY function on a hidden sheet, and then the following 3 IF statements:
IF today + 28 = Mon.-Fri., then give me today + 28.
IF today + 28 = Sat., then give me today + 30.
IF today + 28=Sun., then give me today + 29.

I have tried adding an additional IF statement to address a specific holiday - namely, President's Day on 2/18/08, which is a Monday - but it won't add the extra day, because I think my initial IF statement re: Monday being today + 28 is overriding it.

## 2007 Future Date From A Specified Date

Sep 15, 2009

I'm trying to design an excel sheet where a user will input a date of enrollment, and basing on this date, we would like to get a followup date after one month, and again followup after 6 months. However, I would like it to skip the weekends.

I tried it using: =EDATE(\$C\$2,1) works ok, however =EDATE(\$C\$2,6) gives me a date on Sunday.

## Datedif But For Date In Future And To Return Formatted Time Value

Aug 4, 2009

I need to calculate the difference in Years, Months and Days between:

Date 1 = TODAY()
Date 2 = 4 years after a date in cell A1, which will always be earlier than today's date

(A bit of backround - I have certain risk management procedures that have a lifespan of 4 years. I want to calculate the time between now and 4 years after the date the procedure was completed, essentially to see how long before they have to be redone).

So far I have:

=DATEDIF(A1+4,TODAY(),"y")&"y "&DATEDIF(A1,TODAY(),"ym")&"m "&DATEDIF(A1,TODAY(),"md")&"d"

But that returns #NUM!.

Removing the +4 obviously just calculated the difference between the date in A1 and today, but I need the date in A1 PLUS 4 years and today.

I have also tried:

=(DATE(YEAR(A1)+4,MONTH(A1),DAY(A1))-TODAY())/365.25

which works in theory, however:
a) no consideration for leap years
b) does not return nY, nM, nD - only the decimal.

However I would be happy to use this method if I could convert it to Years Months Days.

## How To Calculate Future Dates From Start Date On A Monthly Cycle

Sep 16, 2009

I'm trying to combine monthly calculations with "today" and with "workdays"

Example:

start date = 01/01/2009

today's date 09/16/2009

formula result = 10/01/2009 ; or if 10/01/2009 is a Sunday, result = 09/29/2009 (not 02/01/2009, 03/01/2009, etc)

=edate gives me a month but it doesn't skip weekends or calculate beyond today's date

## Month View Control To Locate Future Date (Or Red Circle)

May 7, 2014

I had a Calendar Control (2007) but now stuck using 2013. I have to change all of codes related to my Calendar Control to a Month View Control. Problem is I had 4 command buttons beside my calendar to automatically add value to the calendar:

My Code is in a userform. Standard code for MonthView:

[Code] ....

Basically it was â€śhighlightingâ€ť the todays date but if one of the cmd_button was clicked then it would highlight the todayâ€™s date plus 15 (making the highlighted date, if we take today as an example: 2014/05/22).

Now with the Month View is there a way to select the exact same thing? I mean I know if I deactivate the â€śShow Todayâ€ť in the properties but is there a way to make the selected date to have the â€śCircle in Redâ€ť around the date IF I click on a command button?

## Calculate Future Dates From Start Date With Varying Time Period/cycle

Sep 11, 2009

I need to determine a formula which will allow me to calculate a future date based upon a current date with varying time periods.

For example:

I have a bill which is paid on the 15th and last business day of each month. I would like to be able to see the next due date regardless of what day of the week it is.

I have a bill which is paid every other Tuesday. I would like to know the next due date without having to enter +14 for every due date in the future. In other words, it is preferable to be able to open the spreadsheet and automatically see the next due date, not use autofill to repeatedly add +14 to a previous date which would limit the # of future due dates that could be calculated.

I have a bill which is paid on the last business day of each month, not the last Friday of each month. I would need excel to return a value for the last day of the month which = Monday-Friday, regardless of what day of the week it may be as long as it isn't Saturday or Sunday(holiday exclusion would be nice but not required).

## Calculating Age From Date Of Birth

Sep 16, 2009

how to calculate the age from the date of birth and was given these two responses

1) I may be way off here but all that coding seems a waste !

I have in cell A1 = BLANK <--- enter your DOB here

I have in cell A2 =NOW()

in cell A3 do = A2-A1

Format that to General

In Cell A4 do =A3/365

Format that to no deciamal places and you get the age - this one is adding a year to everyones age?

2) Alternatively, if the DOB is A1 :-

=INT(YEARFRAC(A1,TODAY(),1)) - This one does not work it is saying there is an error with the "yearfrac"?

It is also when I am trying to put these into a pivot table, the pivot table is listing these down to 5 decimal places( when I have formatted to zero)????

## Calculating Due Date From One Of Two Cells?

Mar 25, 2014

At the moment I have a simple formula that calculates the due date of a task

The log in date is in cell B3, I use a simple formula in cell F3 "=B3+20" - This gives me the due date

I now need to add another log in date but use the same due date cell

So now ....

Either B3 or D3 will contain a date - whichever one is populated I will need the due date displayed in cell F3

## Calculating Age When Given Only Date Of Birth

Sep 6, 2005

http://www.cpearson.com/excel/datedif.htm
--

"malvis" wrote:

> Is there a formula that can calculate age when given only Date of Birth?

## Calculating Max Date In A Range?

Oct 13, 2011

I have a need to calculate the latest and earliest date in a given range, but I cannot seem to make it work properly. The range looks like this:

Code:
23/08/201120/08/2011 13/08/11 13/08/11 13/08/11 13/08/11
and the code is:

Code:
d1ST = Application.WorksheetFunction.Max(rRow)

No matter the information in the range, the statement is returning "0" (or "12:00:00") - I have tried setting d1ST as a date and double data type.

## Calculating Date Of Payment?

May 2, 2014

I have a list of several hundred loan recipients who are all starting to pay their loans back on different dates. I am able to get the calculation to work so that I just need to put in the start date and excel works out the other 5 or 6 payment dates.The problem is, some people pay back on the 29th, 30th of the month which is giving me a headache when they are supposed to pay in February. The formula I am using calculates the next date of payment to be on the 3rd March (skipping the February payment all together).

The formula I am using is : =DATE(YEAR(A10),MONTH(A10)+1,DAY(A10))

## Calculating The Date At The End Of Each Week

Apr 24, 2007

I am trying to create a formula that returns the date on the friday (ie last working day) of whatever week I am currently in. So, for example, I guess I would use the 'TODAY' or 'NOW' function somewhere to determine the present date - but how do I then determine the date on the Friday of the current week?

## Formula For Calculating End Date

Oct 4, 2009

I was trying to figure out how you could caluculate a project end date, based on a start date (dd,mmm,yyyy) and a project duration of lets say 5 work day and the work week is five days long (monday to friday). If i have a leave on the week days like tuesday is bank holiday then it should give be the date excluding that tuesday and wednesday leave and caluculate 5 working days and shoule give the project end date.

Example date: 5-Oct-09

Project end date:09-Oct-09

If i have bank leave on 06-Oct-09 means.

My project end date:12-Oct-09

Note:Bank holidays are fixed date example(every year bank holiday 06-oct-09,02-Dec-09,25-Dec-09)

Please dont need a macro.

## Calculating Friday Date

Aug 7, 2006

I have dates listed in column A indicating the day an action was performed. In column B I need to have the date in column A changed to a Friday. If the date in column A is not a Friday, then the date in column B needs to fall back to the previous Friday. For example, if the date entered in column A is today, Monday August 7, then the date in column B that I would be Friday August 4. Can anyone think of code that determine this and place the value in column B? Currently I use vlookup to go to another sheet where all the possible dates are listed with their respective Fridays, but this slows down the calculation worksheet as the file is quite large.

## Calculating Date After X Amount Of Days

Apr 11, 2014

I am trying to determine a formula that will tell me what the date will be 61 days and 90 days from a selected date. For example:

A1: 04/11/2014
A2: (Date 61 days from date in A1)
A3: (Date 90 days from date in A1)

Is this possible??

## Calculating Next Due Date For Rental Equipment?

Feb 15, 2014

I have a contract start date. The payment is due every seven days. I have entered the start date. i need the "next due date" to automatically calculate in the "due date column". here is my problem if a customer has a due date say on 2/15/2014 his next due date should be 2/22/2014. regardless if he pays on the 14th or 21st. i need this date to change each time a payment is made.

Copyrights 2005-15 www.BigResource.com, All rights reserved