Dear Gents,
um trying to make a function that determine what is the day number of today from the all year days
Say if the date is 10/1/2017 then this is 10th day from 365 days.
Any help please.
Dear Gents,
um trying to make a function that determine what is the day number of today from the all year days
Say if the date is 10/1/2017 then this is 10th day from 365 days.
Any help please.
Using the Format function, it is "y" - Format(datefield,"y")
I think you didn't understand me well
Today Tuesday November 7, 2017 is Day 311 / 365Day of year is a number between 1 and 365 (January 1 is day 1).
After today there are 54 days remaining in this year.
=Date() - DateSerial(Year(Date()),1,0)