I've just started to use the "How to create leave tracker in Excel" (with easy steps) guide. The formula for inserting the day of the month into the spreadsheet is returning a date and not a day. The formula in the guide is =DATE(Summary!$C$6,1,1) and it returns 01/01/2024 but I only want the day of the month not the date.
[Solved] Create Leave Tracker in Excel - Date to Day
- Thread starter Rona
- Start date
Hello Rona,
You must use the custom format to format the date to show only the day.
You can watch our video tutorial:
How to Create Leave Tracker in Excel
You must use the custom format to format the date to show only the day.
- Select the date cell >> Format Cells >> Custom >> type d.
You can watch our video tutorial:
How to Create Leave Tracker in Excel