Is it BUG or my bad?
Does anyone has this problem?
There isn’t 31 days in November. It’s not a valid date.
1 Like
Hey Jeff Thank you!
I thought this formula works correctly.
I’m getting -1 month from now with Excel formula.
How can I avoid this kinda problems?
Your video shows you manually entering a date. How does that apply to the Excel formula?
I don’t use Excel Formulas. I tend to use the Math column when dealing with dates. If I want to find the last day of the previous month I would use something like this in a math column and replace ‘Now’ with Now.
Now-Day(Now)
2 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.