Analyze Timescaled Data in Excel

[Maria]

Is the Code for this function available anywhere. I want to do something
similar but I can't figure out how to get the months listed along the top-
Also is there a function that can just extract the month portion of a date- i
can't seem to find one.

Thanks

 

[JackD]

Yes you can download the source code.

This is the link I have for the version which came with Project 2000. I
think it is the same for all following versions.
http://www.microsoft.com/downloads/...69-ED3E-4DAB-8EFD-4BAE1B918EC3&displaylang=en
If I remember correctly, the code you are looking for is in in the form5
file. The other forms set up the variables and form5 performs the export.

month(date) will give you the month (as a number) - today it returns "10"

monthname(month(date)) will give you the name of the month - today it
returns "October"

I use date here because it gives the current date. You can replace it with
any fixed date, task.start for example.