Number of days that have passed in the current year


Cell "A1" displays the current date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".

 A
1=TODAY() = Sunday 01 May 2022
2=NOW() = Sunday 01 May 2022 18:37:54
3=A1-DATE(YEAR(A1),1,0) = 121
4=A2-DATE(YEAR(A2),1,0) = 122
5="02/01/2004"-DATE(YEAR("01/01/2004"),1,0) = 01/01/1900
6=DATE(2004,1,2)-DATE(2004,1,0) = 2

Built-in Functions

DATE - The date as a date serial number given a year, month, day.
NOW - The serial number of the current system date and time.


Related Formulas

Number of days between 2 dates
Number of days in a particular month
Number of days that have passed in the current month


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top