LinkBack URL
About LinkBacks
Hi
I am attaching a file in which all formulas were set. The same worked for last month that is may, but is not working for data entered for a new month please help. Data is in Data sheet, and then each individual employee sheet starts.
Hi
I am attaching a file in which all formulas were set. The same worked for last month that is may, but is not working for data entered for a new month please help. Data is in Data sheet, and then each individual employee sheet starts.
try in D2 (Data) =--TEXT(B2,"dd/mm/yy") and copy down
and set Custom format: dd/mm/yy
Last edited by sandy666; 07-03-2017 at 10:28 AM.
Quick question to sandy.
What does the "--" do in the context of this formula? I know it's used o turn "False" and True" into 0 and 1 but not sure here unless its turning the date seriel number from text to an actual number
=TEXT(B2,"dd/mm/yy")
=--TEXT(B2,"dd/mm/yy")
=TEXT(B2,"dd/mm/yy")*1
=TEXT(B2,"dd/mm/yy")+0
you can choose which one you like (or the one that works in this case)
-- , with one - you will get negative value so you need second - and it works like : - * - * TEXT(B2,"dd/mm/yy")
extended version: -1*-1*TEXT(B2,"dd/mm/yy")
why double unary? because it is faster than other one. Double hit one key and that's all
If that takes care of your original question, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED. Thanks.
Last edited by sandy666; 07-03-2017 at 12:00 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks