month of achievement formula

[ELY80]

Hello all,

Please if anyone can help me with this topic. I have an agreement set as a value to be achieved , and billed revenue for each month for a 24 month timing. I have also s start and end date of the agreement. I have found if the target has been achieved or not but cannot identify in which month this target has been achieved.
Could you please help me identify the month?

 

[James006]

Hello,

To get the month .. you can use the Month() function ...

=Month(yourdate)

HTH