By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

Dates and times

Date functions to know

Now()

Weekday()

CVDate()

Format()

Date

#3/22/2024#

Date as a sequential number

half an hour from now
Now() + .5 / 24

How do dates work

Convert a string to a date

CVDate( )

Create Calendar

Sheet below

Code to create a list of tasks and dates based on the release date and tasks with release date offset

Get Dates for Report

This routine will go through an Excel file and extract unique dates after removing items that aren't needed.