List of Dates

  • Thread starter Thread starter SamDev
  • Start date Start date
S

SamDev

I want to create a report that lists all available working dates between on
a start date and end date. These start/end dates will change each month. I
don't want to create formulas that adds 30 to the start date etc because
obviously not all months have 31 days and then there are leap years to
consider.

I know there must be a simple way of doing this but I can't figure it out -
any help is appreciated.

Thx!
 
Just use the month and Year function
month(mydateField)=month(date()) and year(MyDateField)=Year(date())
 
Back
Top