I am attempting to track sales according to day of the week. I do not wish to enter the full date into the spreadsheet as each sheet will be completed monthly and the month/year is noted in the title.
Basically, I am looking to enter "15" and have the next cell tell me what day of the week that is "Thu"
I have no problem changing this formula at the beginning of each month accordingly, but if I don't, then you are even more awesome!
Thanks alot and have a great day!
Re: Enter day of month in one cell (ex. 15), second cell calculates day of week (ex.
You say the month and year are listed in the title. Do you mean the sheet name or in a cell somewhere on the sheet?
Assuming the year and month are in A1 and the you enter 15 in cell B2 place this formula in C2
=IF($B2<>"",DATE(YEAR($A$1),MONTH($A$1),DAY($B2)),"")
the ranges can be modified to suit your needs
Re: Enter day of month in one cell (ex. 15), second cell calculates day of week (ex.
I apologize as I am not following you? I have listed the month and year in the sheet name, I can put it into the spreadsheet easily enough but am unsure what to do with the ranges, please forgive me, I am new.
Re: Enter day of month in one cell (ex. 15), second cell calculates day of week (ex.
We all start new at somepoint.
Since you are using the sheetname as the month and year reference, use this formula
=IF($B2<>"",DATE(YEAR(TEXT(MID(CELL("filename"),FIND("]",CELL("filename"))+1,255),"mmm-dd")),MONTH(TEXT(MID(CELL("filename"),FIND("]",CELL("filename"))+1,255),"mmm-dd")),DAY($B2)),"")
This assumes that the date value you will enter is in B2. You can change this cell to whatever location you are actually using.
change the cell format to "ddd" to display the three letter day of the week(under custom format and type ddd in the display box)
Don’t have an account yet? Register yourself now and be a part of our community!
