Hello Guys,
Need Help!
I am currently using a Weekday count formula; which works perfectly if only date is entered in date column "B". But, if i mentioned time with date in same cell then it start giving error.
The sample file is attached for your reference.
Thanks,
Last edited by Manish_Gupta; 12-03-2013 at 02:56 PM.
Hi M,
try this workaround. Replace B5 in the formula with: (B5-HOUR(B5)/24)
Cheers
<-- If you're happy & you know it...click the star.:-)
hi Manish. try using INT to get just the date:
Formula:
Please Login or Register to view this content.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks