What kind of date manipulation can I do?

1. Add or Subtract Months from a Date:

   • Add 3 months to the date in {column}
   • Subtract 2 months from the date in {column}
   • create a new column {column_name} and populate it with {column_name} + 3 months

2. Find the Last Day of a Future Month:

   • Create a new column called last day and populate it with the last day of the month 5 months from now

3. Calculate Workdays:

   • Create a new column called number of workdays and populate it with the the number of workdays between date_column_1 and date_column_2

4. Calculate Workdays with Holidays:

   • Count workdays between column A and column B, considering US national holidays and populate in {new_column}

5. Calculate Date Differences:

   • How many months are there between date column A and date column B

Date Grouping and Aggregation Functions:

1. Find the Week Number of a Date:

   • e.g., "What's the week number of March 20, 2023?"

2. Get the Name of a Month:

   • e.g., "Give me the name of the month for December 25, 2023."

3. Get the Name of a Day:

   • e.g., "What's the day name for October 10, 2023?"

4. Convert Date to a Custom Text Format:

   • e.g., "Change the date to a format like 'MM/DD/YYYY'."

5. Calculate the Fraction of a Year:

   • e.g., "Find the fraction of a year between two dates."

6. Aggregate Data Based on Date Conditions:

   • e.g., "Sum all values where the date is in March and the amount is above 100."