Excel I am trying to create the following for my company and am stumped: Start Date * Rate of Starts per week(WORKDAY) = Finish Date I would like to change the rate of starts to give the finish date. ...
functions if enter a date 01-02-08 the last date of the month .in excell this formuloa is eomonth() The eomoth function returns the last day of the month. Use EOMONTH to calculate maturity dates or ...
Formula for Date I have a attendance data, this data doesnt show a date if employee is absence or doesnt swap a Card. How I can get the missing date with the dates which I have available atleast I ...
CAN'T CALCULATE DATES TO GIVE DEADLINE ATTEMPTING TO CREATE A SPREADSHEET THAT WOULD ALLOW START DATE AND DEADLINE, CANT PRODUCE INFO WITH FORMULA WORKDAY= cell 1 (date format) = start date cell 2 ...
Need excel solution This is what i need to do. I need to calculate accumulated hours from two inputs. example. Create date: 10/19/2008 13:08 Due date: 10/23/2008 13:08 then i need a formula that will ...
Need to Add Dates in Excel I have a fixed assets excel sheet that shows the date an item was purchased. Example: 12/21/2006. I need to show a date for estimated remaining life of this item. Since most
DATE DIFERANCE BETWEEN SELECTED COLOUMN 02/04/08 05/04/08 04/06/08 08/05/08 10/07/08 05/07/08 ABOVE COLUMN 4 TH MONTH =APR, 5 TH MONTH=MAY..... I MEAN I FOUND APR. MAY. JUNE JULY ETC... PLESAE HELP ME
converting date of a month to last working day of the month I want to calculate date of retirement of some staff members. But the problem is that it is calculating date of retirement from date of ...
I copied the following: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Not Intersect(Target, Range(''A2:A100'')) Is Nothing Then With Target(1, 2) ...
workday function in excel formulas The WorkDay Function returns a number that's the serial date that is the indicated number of working days from a given date (the starting date). Working days EXCLUDE
Usually answered in minutes!
592 Questions
43 Questions
22 Questions
12 Questions