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 want to achieve the following;
1. How to i display the date in 'friendly format', currently it's 18/07/2020, I would like July 18 2020
2. I only want to apply this formula when a column named 'Category' is equal to 'Desktop'
How can I achieve this?
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)
