I have a function:
= Today()
To get today is 09/11/2007 (i know it is Friday)
How do i get Monday 05/11/2007?
and how do i know today is Friday with what formula? Show me...
I have a function:
= Today()
To get today is 09/11/2007 (i know it is Friday)
How do i get Monday 05/11/2007?
and how do i know today is Friday with what formula? Show me...
=TEXT(TODAY(),"dddd")
=TEXT(TODAY()-5,"dddd")
-5 is SUNDAYOriginally Posted by davesexcel
-4 is MONDAY
u can show me how to get MODAY = 05/11/2007?
Are you trying to get the actual date for Monday? If so,
=TEXT(TODAY()-4,"dd/mm/yyyy")
place the date in A1Originally Posted by lunar_star
=TEXT(A1,"dddd")
It's work perfect. ThxOriginally Posted by davesexcel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks