Scribd
Upload
8 views

Unsolved Date Function

Uploaded by

abil9n
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
8 views

Unsolved Date Function

Uploaded by

abil9n
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

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")

You might also like