Need formula for date? Results in Weekdays. Date1 - Date2 = Weekdays. But sometimes Date2 will be empty so I need the formula to use Todays Date when Date2 is empty?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Photo of kelly

kelly

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,548 Points 50k badge 2x thumb
I assume you want to count weekdays excluding weekends.


Try this

var date DateTwoOrToday = IF(not IsNull(Date 2],[Date 2], Today());

WeekDaySub([Date 1], $DateTwoOrToday)
Photo of kelly

kelly

  • 0 Points
Thank you but I'm new to Quickbase and using the formula editor; can you explain your suggestion a little bit more like what "Function" do I select?  and could you make it cut and paste - sorry I need a little more tutoring - Thank You!
Photo of kelly

kelly

  • 0 Points
Thank you but I'm new to Quickbase and using the formula editor; can you explain your suggestion a little bit more like what "Function" do I select?  and could you make it cut and paste - sorry I need a little more tutoring - Thank You!