Skip to main content
added 23 characters in body; edited tags
Source Link
Ganesh Sanap - MVP
  • 46.4k
  • 22
  • 31
  • 63

As is, the formula below works perfect for my project.. 

However, I would like to spice it up by having the results just display the Month and the Year of the "Next Test Date". Also, is there a way to avoid adding by days (example "+365" or "+182") and just add by months??

working with SharePoint Online if that helps.

I assume I need the following added but I dont know how to merge it to the current Formula.. =TEXT([Created],” (MMM YYYY)”)

=TEXT([Created],” (MMM YYYY)”)

Current working Formula: =IF(OR(AND([Mil Status]="AGR",[Composite Score]>=90),AND([Mil Status]="DSG",[Composite Score]>=75)),[Previous Test Date]+365,(IF(OR(AND([Mil Status]="AGR",[Composite Score]>=75),AND([Mil Status]="AGR",[Composite Score]<=89)),[Previous Test Date]+182)))

=IF(OR(AND([Mil Status]="AGR",[Composite Score]>=90),AND([Mil Status]="DSG",[Composite Score]>=75)),[Previous Test Date]+365,(IF(OR(AND([Mil Status]="AGR",[Composite Score]>=75),AND([Mil Status]="AGR",[Composite Score]<=89)),[Previous Test Date]+182)))

As is, the formula below works perfect for my project.. However, I would like to spice it up by having the results just display the Month and the Year of the "Next Test Date". Also, is there a way to avoid adding by days (example "+365" or "+182") and just add by months??

working with SharePoint Online if that helps.

I assume I need the following added but I dont know how to merge it to the current Formula.. =TEXT([Created],” (MMM YYYY)”)

Current working Formula: =IF(OR(AND([Mil Status]="AGR",[Composite Score]>=90),AND([Mil Status]="DSG",[Composite Score]>=75)),[Previous Test Date]+365,(IF(OR(AND([Mil Status]="AGR",[Composite Score]>=75),AND([Mil Status]="AGR",[Composite Score]<=89)),[Previous Test Date]+182)))

As is, the formula below works perfect for my project. 

However, I would like to spice it up by having the results just display the Month and the Year of the "Next Test Date". Also, is there a way to avoid adding by days (example "+365" or "+182") and just add by months??

working with SharePoint Online if that helps.

I assume I need the following added but I dont know how to merge it to the current Formula.

=TEXT([Created],” (MMM YYYY)”)

Current working Formula:

=IF(OR(AND([Mil Status]="AGR",[Composite Score]>=90),AND([Mil Status]="DSG",[Composite Score]>=75)),[Previous Test Date]+365,(IF(OR(AND([Mil Status]="AGR",[Composite Score]>=75),AND([Mil Status]="AGR",[Composite Score]<=89)),[Previous Test Date]+182)))
Source Link

Calculated Column to show only Month and Year from formula results?

As is, the formula below works perfect for my project.. However, I would like to spice it up by having the results just display the Month and the Year of the "Next Test Date". Also, is there a way to avoid adding by days (example "+365" or "+182") and just add by months??

working with SharePoint Online if that helps.

I assume I need the following added but I dont know how to merge it to the current Formula.. =TEXT([Created],” (MMM YYYY)”)

Current working Formula: =IF(OR(AND([Mil Status]="AGR",[Composite Score]>=90),AND([Mil Status]="DSG",[Composite Score]>=75)),[Previous Test Date]+365,(IF(OR(AND([Mil Status]="AGR",[Composite Score]>=75),AND([Mil Status]="AGR",[Composite Score]<=89)),[Previous Test Date]+182)))