Returns the reporting period month
Scenario: I need a formula that returns the reporting period month. Any date after the said date of the month, it will return a reporting period of the following month.
If(
(Month([Date])="Janua...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe month function returns the number of the month= and not the name
Try this approach
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Try this approach
If(
(Month([Date])=1 and Day([Date])>21)
or
(Month([Date])="3" and Day([Date])>25)
etc etc etc
(Month([Date])=9 and Day([Date]>30),
Month(AdjustMonth([Date], 1)), Month([Date])
)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------