| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Build DateSeries (?)
Hi All,
I have the following range of dates/times Start Date 1 Jan 08 12:00 hrs End Date 21 Nov 08 09:30 hrs Increment by 15 days Need to develop a VBA routine that builds a two column series as follows Col A ColB StartDate StartDate + Increment StartDate + Increment StartDate + Increment + Increment etc to EndDate Calculating the total time between dates in each row should give you a total time between SatrtDate and EndDate of 324.8958333 Days. As validation I will need to calcualte the total time between dates in each Row Can anyone assist me in this please! Many thanks/sgl |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to build a database | New Users to Excel | |||
| How would I build an "if" formula... | Excel Worksheet Functions | |||
| How to build build a macro that automatically imports | Excel Programming | |||
| Build a Macro | Excel Programming | |||
| Build Add-in in C++ | Excel Programming | |||
Threaded Mode
