Date and time function
to see the current date formula short cut key
2/4/2025 2/4/2025 11/27/2024
to see the current time formula short cut key
2/4/2025 12:32 2/4/2025 12:32 1:40:00 PM (cntrl+shift+:)
example for text (): to find day and month name of the date
date text(day) day short name
11/27/2024 27 Wed
6/10/2024 10 Mon
3/4/2003 04 Tue
5/4/2001 04 Fri
00 Sat
date text(month) number month short name
2/4/2025 02 Feb
8/10/2024 08 Aug
3/4/2003 03 Mar
5/4/2001 05 May
example for datedif(to find the differencess between 2 dates)
start date of project end date of project days to complete the project
### ###
Saturday, March 4, 2000 Saturday, May 6, 2000
Mnf date expire date months
2/1/2021 4/20/2021
DOJ todays years
2/1/2000 2/4/2025
=TODAY()
weeknum: to display the number of weeks completed in the given year
date weeks fromula
###
###
current day: =today()
current time: =now()
d month name of the date
day full name
Wednesday =TEXT(A12,"DD") =TEXT(A12,"DDD") =TEXT(A12,"DDDD")
Monday =TEXT(A13,"DD") =TEXT(A13,"DDD") =TEXT(A13,"DDDD")
Tuesday =TEXT(A14,"DD") =TEXT(A14,"DDD") =TEXT(A14,"DDDD")
Friday =TEXT(A15,"DD") =TEXT(A15,"DDD") =TEXT(A15,"DDDD")
Saturday =TEXT(A16,"DD") =TEXT(A16,"DDD") =TEXT(A16,"DDDD")
month full name
February =TEXT(A18,"MM") =TEXT(A18,"MMM") =TEXT(A18,"MMMM")
August =TEXT(A19,"MM") =TEXT(A19,"MMM") =TEXT(A19,"MMMM")
March =TEXT(A20,"MM") =TEXT(A20,"MMM") =TEXT(A20,"MMMM")
May =TEXT(A21,"MM") =TEXT(A21,"MMM") =TEXT(A21,"MMMM")
erencess between 2 dates)
fromula
formula
formula
#N/A
eks completed in the given year
=TEXT(A12,"DDDD")
=TEXT(A13,"DDDD")
=TEXT(A14,"DDDD")
=TEXT(A15,"DDDD")
=TEXT(A16,"DDDD")
=TEXT(A18,"MMMM")
=TEXT(A19,"MMMM")
=TEXT(A20,"MMMM")
=TEXT(A21,"MMMM")
