Forum Discussion

jonboylib's avatar
jonboylib
Iron Contributor
Aug 19, 2022
Solved

SP Calculated Date

I am using the formula below - taken from here    =DATE(YEAR([Date Purchased])+4,MONTH([Date Purchased]),DAY([Date Purchased]))   This successfully adds 4 years to my Date Purchased column. Now I...
Lists
SharePoint Online
  • RobElliott's avatar
    RobElliott
    Aug 19, 2022

    jonboylib  =TEXT(DATE(YEAR([Date Purchased])+4,MONTH([Date Purchased]),DAY([Date Purchased])),"mmmm dd yyyy")

     

    To only apply this formatting when Category = Desktop use this:

     

    =IF(Category="Desktop",TEXT(DATE(YEAR([Date Purchased])+4,MONTH([Date Purchased]),DAY([Date Purchased])),"mmmm dd yyyy"),DATE(YEAR([Date Purchased])+4,MONTH([Date Purchased]),DAY([Date Purchased])))

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

RobElliott's avatar
RobElliott
Silver Contributor
Aug 19, 2022

jonboylib  =TEXT(DATE(YEAR([Date Purchased])+4,MONTH([Date Purchased]),DAY([Date Purchased])),"mmmm dd yyyy")

 

To only apply this formatting when Category = Desktop use this:

 

=IF(Category="Desktop",TEXT(DATE(YEAR([Date Purchased])+4,MONTH([Date Purchased]),DAY([Date Purchased])),"mmmm dd yyyy"),DATE(YEAR([Date Purchased])+4,MONTH([Date Purchased]),DAY([Date Purchased])))

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

jonboylib's avatar
jonboylib
Iron Contributor
Aug 19, 2022

RobElliott Thanks for this.

 

What about my second requirement, any ideas?

 

2. I only want to apply this formula when a column named 'Category' is equal to 'Desktop'

Resources