Скачать или смотреть Excel - Words With Dates: Episode 1517

Microsoft Excel Tutorial: How to Display Words with Dates in Excel Using Custom Number Formatting | MrExcel Podcast.

Welcome to the MrExcel podcast. In this episode, we will be discussing words with dates. I'm Bill Jelen and today's question comes from a viewer on YouTube who is looking for a way to calculate a cell based on a date in another cell. Instead of using complicated functions, I have a simple solution that involves custom number formatting.

On the second worksheet, I have entered a date in cell A1 and formatted it as a custom number with the words "payroll as of" before the date. This way, the cell still contains a true date value, but it is displayed as a phrase. To do this, I went to the home tab and clicked on the format cells dialog launcher, or you can use the shortcut [ctrl 1]. Then, I selected the custom number format and added the words "payroll as of" in quotes before the format. This will show the words before the date in the cell.

Now, to calculate the cell A8 based on the date in A1, we can simply use the formula =A1+14. This will add 14 days to the date in A1, giving us the next payroll date. We can then copy this formula down for each additional payroll period. This way, we are able to store a real date value in the cell, but display it as a phrase using custom number formatting.

Thank you for tuning in to this episode of the MrExcel podcast. I hope this tip helps you in your Excel journey. Don't forget to subscribe to our channel and hit the notification bell to stay updated on our latest videos. See you next time for another netcast from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...


Table of Contents:
(00:00) Words with Dates
(00:12) Solution using Custom Number Formatting
(01:50) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Custom number format in Excel
Date function in Excel
Episode 1517
Excel formula
Format cells in Excel
Payroll calculation in Excel
Payroll data
Words with Dates


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...

From a YouTube Viewer, Bill looks how to have text and actual dates reside in the same Cell. Follow along with Episode #1517 to learn how to add Custom text to your Date Field while retaining the actual Date.

...This episode is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!

"The Learn Excel from MrExcel Podcast Series"

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!