Forum Discussion
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/...
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)
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)