GETPIVOTDATA ASCENSIONTHURSDAY

Date/Time

  • ASCENSIONTHURSDAY — Ascension Thursday in the Gregorian calendar according to the Roman rite of the Christian Church
  • ASHWEDNESDAY — Ash Wednesday in the Gregorian calendar according to the Roman rite of the Christian Church
  • DATE — create a date serial value
  • DATE2HDATE — Hebrew date
  • DATE2HDATE_HEB — Hebrew date in Hebrew
  • DATE2JULIAN — Julian day number for given Gregorian date
  • DATE2UNIX — the Unix timestamp corresponding to a date d
  • DATEDIF — difference between dates
  • DATEVALUE — the date part of a date and time serial value
  • DAY — the day-of-month part of a date serial value
  • DAYS — difference between dates in days
  • DAYS360 — days between dates
  • EASTERSUNDAY — Easter Sunday in the Gregorian calendar according to the Roman rite of the Christian Church
  • EDATE — adjust a date by a number of months
  • EOMONTH — end of month
  • GOODFRIDAY — Good Friday in the Gregorian calendar according to the Roman rite of the Christian Church
  • HDATE — Hebrew date
  • HDATE_DAY — Hebrew day of Gregorian date
  • HDATE_HEB — Hebrew date in Hebrew
  • HDATE_JULIAN — Julian day number for given Gregorian date
  • HDATE_MONTH — Hebrew month of Gregorian date
  • HDATE_YEAR — Hebrew year of Gregorian date
  • HOUR — compute hour part of fractional day
  • ISOWEEKNUM — ISO week number
  • ISOYEAR — year corresponding to the ISO week number
  • MINUTE — compute minute part of fractional day
  • MONTH — the month part of a date serial value
  • NETWORKDAYS — number of workdays in range
  • NOW — the date and time serial value of the current time
  • ODF.TIME — create a time serial value
  • PENTECOSTSUNDAY — Pentecost Sunday in the Gregorian calendar according to the Roman rite of the Christian Church
  • SECOND — compute seconds part of fractional day
  • TIME — create a time serial value
  • TIMEVALUE — the time part of a date and time serial value
  • TODAY — the date serial value of today
  • UNIX2DATE — date value corresponding to the Unix timestamp t
  • WEEKDAY — day-of-week
  • WEEKNUM — week number
  • WORKDAY — add working days
  • YEAR — the year part of a date serial value
  • YEARFRAC — fractional number of years between dates
GETPIVOTDATA ASCENSIONTHURSDAY