Forum Discussion
Please Help - Formulas and Dates
Hello, I am trying to create a column that would take a date from one cell and add 9 Months and 1 Day, therefore returning a date of 9 months and 1 day later. My issue is, while using the normal ...
TheAlchemist 9 months and 1 day is 274.75 days, so why not just have a calculated column that adds that to the date i.e =[Review Date]+274.75
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Hi Thank you!
Unfortunately as you can see the 5 April date gives you a day before not after 😞 Therefore some errors will occur. On excel you can do what I need to do by using EDATE, sadly SharePoint doesn't have that function 😞
Unfortunately as you can see the 5 April date gives you a day before not after 😞 Therefore some errors will occur. On excel you can do what I need to do by using EDATE, sadly SharePoint doesn't have that function 😞