What is the formula to return the 13th day of the previous month?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
If today's date is August 21, 2015 then I want the formula to return July 13, 2015.

or if today's date was January 8, 2016 then I want the formula to return December 13, 2015.  

Thanks
Photo of Robin CC

Robin CC

  • 220 Points 100 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Try this, (not tested)

var Date LastMonthToday = AdjustMonth(Today(), -1);

Date(Year($LastMonthToday), Month($LastMonthToday), 13)
AdjustMonth(FirstDayOfMonth(Today()), -1)+Days(12)

Try that.

(Tested and works)
Photo of Robin CC

Robin CC

  • 220 Points 100 badge 2x thumb
Thanks Mark.  That works.  I just had to add in the missing $
Photo of Robin CC

Robin CC

  • 220 Points 100 badge 2x thumb
Thanks.  That works too.