98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Filter
Filter
Resolved · Low Priority · Version 2003
Gavin has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Filter
Can I still use =today method for tracking distance between 2 dates when I have sort function on the spreadsheet?
RE: Filter
Hi Gavin
Thank you for your question, and I hope you are enjoying your third day of Excel training!
I've attached an example which shows the current date using the today function, and then a list of dates, and the number of days between the current date and the date in column A which is calculated using a formula.
If you sort the list, you should find that the formulas still work ok.
I hope this helps.
Amanda
Attached files...
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Find cells that match a formatIn Excel you may wish to find cells that contain a specific formatting such s colour. |