calculate month

  1. D

    Month by Number

    Hello, I am wondering if there is a way to calculate months mathematically. For example, if this month is October (10) and I want to go back 3 months to July (7), is there an easy way to show this? Here's what I have: <tbody> A B 1 10 <--using "=MONTH(TODAY())" 2 Oct <--using...
  2. L

    Apportion project in months across year columns

    Hi i need to apportion our projects (ie the no of months it was live across a range of years) so i can then apportion the turnover. I'm stuck at the calculating months end. eg a2 = start date , b2 = end date in columns c - g i have the years - 2005, 06, 07, 08, 09 project X runs from jun...

Some videos you may like

This Week's Hot Topics