Question about a specific function of microsoft Excel
By prince05
@prince05 (92)
Philippines
April 24, 2012 8:26pm CST
Yesterday I created a table for my company to automate the day into 5th day,10th day,15thday,20th day. The table is so simple i just need to enter the number value which is the date for today and it gives me the date for the 5th,10th,15th,20th day consecutively. I used they DAY function in this method, my problem is it is set to work from 1 to 31, is there a way to make it work from 1 to 30 for months ending only with 30 days and 1 to 28 for months in February? Anyone good at excel here please help me and answer my query.
1 person likes this
3 responses
@owlwings (43915)
• Cambridge, England
25 Apr 12
It's not quite clear what you mean to do or how you want it to appear.
If you want to simply calculate the 5th, 10th, 15th and 20th day from today (whenever that is) and display each date, then you only need to enter:
=today()+5, =today()+10, &c in the appropriate cells (formatted as Date)
If you need the 5th, 10th &c days from a particular date, enter the start date in a cell (for example, A1) and then:
=A1+5, A1+10, &c in the cells which show the 5th, 10th &c days after that date.
I don't see why you would need to use the DAY function at all. This only gives you the day number of the month and, presumably, some of your forward dates will cross the month boundary. Just adding a number of days to a date is all that you need to do because Excel actually treats a date as the number of days after 1 Jan 1900, regardless of how it displays it.
@owlwings (43915)
• Cambridge, England
25 Apr 12
Using TODAY() will mean that whenever the sheet is opened or refreshed, Excel will read the CURRENT date from the PC's internal clock and use that date, of course.
To quickly enter today's date in a cell (and have it fixed as that date whenever the sheet is opened later), use the shortcut Ctrl+;
@prince05 (92)
• Philippines
26 Apr 12
additional question, can I hide the default date that is coming out on each cell?
I want it to appear as there are no number's and when I put the actual date that's the time the results will come out, beacuse what is happening now is for the 5th , 10th, 15th, and 20th cell there is some kind of default date that is coming out which is 01/4/1900 can i hide this? just display to me the date after i typed in the actual date? thanks
@honest_efforts100 (1607)
• India
5 Oct 12
. Microsoft Excel is a data-management program that is used to create and format spreadsheets, analyze and share the information within those spreadsheets, and make charts, graphs and PivotTables. With advanced tools from Microsoft, users can easily share all their information through email, a company Intranet or the Internet. Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating numbers and data.
