Indicating Each Month A Project Is Active?

Community,

I'm struggling to indicate which months a project is active given a project start and end date. If a project starts on 09 January 2020 and ends on 09 March 2020, it would be active January, February, March. I would like to represent this as follows:

Annotation 2020-01-09 100855.jpg

Showing that the project was active in its Start Month and End Month is easy (as in Projects A and B above). For example, I can use...

=IF(OR(MONTH([Project Start Date]1) = 1, MONTH([Project End Date]1) = 1), 1, 0)

...to do this for January.

Where i'm stuck is how to determine the intervening months (as in Projects C and D above). Any ideas?

Thanks in advance.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!