Future Date Formula Help

Question

I want to create at date that is X number of weeks after another date but if the date falls less than or equal to 3 day into any given month then the date should equal the last day of the prior month. What should this formula look like?

------------------------------
George Bramhall
------------------------------

georgebramhall2 · Answer

works like a charm, thank you Mark!!------------------------------George Bramhall------------------------------

markshnier__you · Answer

3 business days or calendar days ?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

georgebramhall2 · Answer

Calendar Days, thanks------------------------------George Bramhall------------------------------

markshnier__you · Answer

Try thisvar RawDate = [Another date] + Weeks([X weeks as a numeric field]);IF(Day($RawDate)&lt;=3, LastDayOfMonth(AdjustMonth($RawDate,-1)),$RawDate)------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

georgebramhall2 · Answer

Now my end user wants different results.If a date lands during the First week of the month, he wants to return the last day of the previous month. What is the best formula to achieve this?------------------------------George Bramhall------------------------------

Forum Discussion

Future Date Formula Help

Related Content

Formula Date Field

Date Field Formula

Add 1 day to date formula

Color Code Date Field based on Formula

Distinct Dates