Forum Discussion

Nathanial_MacIntyre's avatar
Nathanial_MacIntyre
Copper Contributor
Jan 24, 2024

Sharepoint Date + 6 Months

Hello

 

Not very good with sharepoint or formulas, have tried with not much luck

 

Im looking for a formula for "Date" + 6 Months for a column called "due date"(Calculation)

 

so if Date is 10/01/2023 / 10JAN2023 it becomes 10/07/2024 / 10JUL2024

 

Many thanks for the help

SharePoint Online
Usage

3 Replies

  • Rob_Elliott's avatar
    Rob_Elliott
    Silver Contributor
    Jan 24, 2024

    Nathanial_MacIntyre =[Date]+180

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

      • Rob_Elliott's avatar
        Rob_Elliott
        Silver Contributor
        Jan 25, 2024

        Nathanial_MacIntyre well, no it won't as it adds 180 days, and each month doesn't have the same number of days. If you are wanting it to add 6 months and for it to be the same date, e.g. 7th January -> 7th July that's a different question.

         

        Rob
        Los Gallardos
        Microsoft Power Automate Community Super User.
        Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Resources