Hello I have a date question

[Peter_Jenkinso1]

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?

[Steve · Accepted solution]

Try:

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

See also:

help.appsheet.com

AND()

Are all true?

help.appsheet.com

EOMONTH()

Date of last day of a month from Date or DateTime

help.appsheet.com

TODAY()

Current date