Need Year Functions

  • Thread starter Thread starter dano0097
  • Start date Start date
D

dano0097

I have all of the functions for inserting the first day of the previous
month (DateSerial(Year(Date()), Month(Date())-1,1)) and last day of
previous month (DateSerial(Year(Date()), Month(Date()),0)) . Are there
any functions like those for the year? like first day of previous year
and last day of previous year? if there are and i can get them , that
would just make my day! thanks!

Happy Holidays
-Dan
 
I hope I understand what you are asking ...

To calculate the first day of the previous year based on the current
date ... use:

DateSerial(Year(Date())-1,1,1)

To calculate the last day of the previous year based on the current
date ... use:

DateSerial(Year(Date()),1,0)

But if you are wanting to know the literal day .. incorporate the
WeekDay() function with the above to get this value:

WeekDay(DateSerial(Year(Date())-1,1,1))

And ..

WeekDay(DateSerial(Year(Date()),1,0))

RDH
 
Back
Top