| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically enter a percent for each month of the year.
In A1 thru L1 i have months: A1=Jan, B1=Feb, C1=Mar etc
In A2 thru L2 will be total for each month. In A19 i have a percentage ex "34%" that varies up and down every day.. In A20 i have "today()" date ex 3-23-08 At the end of the Month i want the percentage in A19 "34%" to automatically log in to the corresponding month ex. today date 3-23-08 to C2 March Is there a formula for this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
| Enter day, default month and year | Excel Discussion (Misc queries) | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| trying to get day/month/year froamt while user enters year only | New Users to Excel | |||
| How do you change the year but not the month automatically? | Excel Discussion (Misc queries) | |||
Threaded Mode
