# Questions & Answers for: Microsoft Excel date

## Excel

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

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

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

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 calculate how

## Need to Add Dates in Excel

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

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

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

...End With End If End Sub into the view code in excel. It works fine for me time and date stamping when I make an entry in a cell. The problem is when I close the workbook and re open ...

## Workday function in excel formulas

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