I'm looking for something to calculate the following 
If today is between [Participant Start Date] and [Participant End Date] then count the number of days from [Participant Start Date] through today, otherwise show 0.
I'd also like to surround the formula above with another if statement such that if the [Participant Type] is "Residential" the above should executed, and if not then do nothing.
Thanks in advance.
 0 Points
Posted 4 years ago
QuickBasePros (Laura Thacker), Champion
 6,396 Points
If([Participant Type]="Residential" and
Today() >= [Participant Start Date] and Today() <= [Participant End Date], Today()[Participant Start],
null)
QuickBasePros (Laura Thacker), Champion
 6,396 Points
QuickBasePros (Laura Thacker), Champion
 6,396 Points
 0 Points
If([Participant Type]="Residential" and
Today() >= [Participant Start Date] and Today() <= [Participant End Date], Today()[Participant Start Date],
null)
 0 Points
QuickBasePros (Laura Thacker), Champion
 6,396 Points
Related Categories

Formulas & functions
 3108 Conversations
 88 Followers

Tables & fields
 7400 Conversations
 204 Followers