Hi,
Kindly let me know how can I convert all the formula after expiry of any date mentioned there in either in dd-mm-yyyy format or mm-dd-yyyy and so on.
Thanx in advance.
Hi,
Kindly let me know how can I convert all the formula after expiry of any date mentioned there in either in dd-mm-yyyy format or mm-dd-yyyy and so on.
Thanx in advance.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
not sure i understand fully
can you
Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
however, if the dates are formatted as mm-dd-yyyy
then its NOT possible to change that to mean the same date in dd-mm-yyyy
you can change the format OK
BUT
if the date is 1/12/16 and could be in either format
then you will not know what the date should have been
should it be 1st Dec or 12th Jan
excel will use a number from 1/1/1900 to determine the date
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.
Sorry for the delay.I have attached a sample workbook which in one sheet there is data and in another there is mentioned only one formula.
The formula I would like to get converted into values after some date say after 2 days.
dont understand what you want to achieve - sorry
I mean to say the formula which I have applied must get converted into values/text after certain time becoz in actual I have applied a lot of formula which can be viewed only for a limited period of time.Is this can be achieved ?If so,kindly let me know.
you dont want people to see the formula in the cell after a certain time?
yeah of course.
no , i do not know a way
not sure if locking a cell hides the formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks