The formula described here will provide a calculated date in a report. Typically you would display a date as a static number or a range, but the process explained below will enable you to display specific dates like "the first Monday of the month" or "every second Wednesday."
Some common calculated date formulas:
=DATEVALUE(DATE(YEAR(NOW());MONTH(NOW());1))
=DATEVALUE(DATE(YEAR(NOW());MONTH(NOW());DAY(NOW())-WEEKDAY(Now();2)))
=DATEVALUE(DATE(YEAR(NOW());MONTH(NOW());DAY(NOW())-WEEKDAY(Now())+7))
=NOW()
=TODAY()
=DATEVALUE(DATE(YEAR(NOW());MONTH(NOW());DAY(NOW()-1)))