Mar 15 2021 12:34 AM
Hi,
I have a column (Performed) that I input the date I did an activity. I am trying to create a calculated column (Due) where it is due 3 months after the Performed date. I know I am able to achieve this by using this formula:
=DATE(YEAR([Performed]),MONTH([Performed])+3,DAY([Performed]))
However, I want to set the date on the 1st of that month. For example, when the performed date is on 20 DEC 2020, the due should be on 1 MAR 2021. Is this possible?
Thanks in advance :)
Mar 15 2021 04:49 AM
SolutionMar 15 2021 08:44 AM
Dec 28 2022 05:08 PM
Hi there!
Thank you Don for that answer! Fantastic info!
I'm wondering if you have any suggestions on an easy-ish way to create a view in a document library for what I need.
Basically... view that will filter from the 11th of last month through the 10th of the current month.
For example - today is 12/28, so we are in the December invoice cycle, and I need to see 12/11 - 1/10. If today was December 6, we would be in the November invoice cycle and need to see 11/11 - 12/10.
Thanks in advance if you're able to help!!
Mar 15 2021 04:49 AM
Solution