Hi, I have 2 adjacent cells C5=Today()-1 and D5=Today(). And there are 100's of numbers under them and getting compared based on look up by date. Everything works fine till I hit Monday and that's where I need C5 to display Friday and not Sunday. Thought =IF(Today()=Monday,Today()-3,Today()-1 would work but I was wrong.
Any solutions? I am trying not to use VB.
Thanks
N
you need weekday()
so
Weekday(today(),2)
which will give back a number starting with Monday as a 1
so
If( Weekday(today(),2) = 7, Today()-3,Today()-1 )
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
You could use
=WORKDAY(F3,-1)
or if you want to use the IF statement,
IF(Weekday(D5)=2, TODAY()-3, TODAY()-1)
Either of these work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Try
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
=workday(today(),-1)
Thank you all, all solutions worked!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks