Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Retrieve a date from Excel to add days in VB

Status
Not open for further replies.

28861

Computer
Jul 25, 2002
1
I am using a spreadsheet from Excel97 as my database and am using VB 5 as the front end. I have entered a Initial Launch Date into the database and I want to add days to this date in order to calculate a due date. Can someone give me some hints?
 
Replies continue below

Recommended for you

Dates in Excel are simply numbers indicating the number of days from a given start date (should be 1/1/1900).
So you can manipulate this just adding a number of days (also fractional): you'll get back the corresponding date in Excel when the cell receiving the datum is formatted as date or hour. prex
motori@xcalcsREMOVE.com
Online tools for structural design
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor