Hello I have a date question

How would I make this may week instead on a day?

AND(NOW() > [Date Start], HOUR(NOW() - [Date Start]) < 24)

its for a slice I want to show from now till the end of the month?

Try:

AND(
  ([Date Start] >= TODAY()),
  ([Date Start] <= EOMONTH(TODAY(), 0))
)

See also:



4 Likes