Generic date in Entry Table

J

Jim

In summary, I'm trying to show generic date information in the entry table in
Gantt view. Project starts in June-06, which I would like to show as Y1M1.
July would be Y1M2 and so on.

You are welcome Jim.

It *may* be possible through VBA, but I'm afraid that isn't one of my
skills. You may get an answer if you post to the project developer
site.

Julie
 
R

Rod Gill

I think Gerard gave the easiest answer in the Project group. Use DateDiff to
calculate the month in Text1, Datediff to calculate the year in Text2 then a
formula in Text3 to concatenate text 1 and 2.

VBA can certainly do this, but formulae will calculate each time a task's
date changes, whilst you would need to manually run a vba macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

gantt timescale 2
How to Round a Date to a Month 2
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Entry table "Start" and "Finish" dates year off of Gantt 1
Change the default date format 1
Data entry to table from a form 0
Dynamically sized table compiled from unsorted rows with blank entries 2
Excel file for deliberations on proper entry date into a retirementplan 1

Top