Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi. I need help finding a formula to calculate the number of days in a month
depending on the month you choose from a drop down menu. Example: In cell A1 user will be ask to select a month from a drop down menu. In cell B1 I want the number of days in the month corresponding to the month selected in A1. So, if February is chosen on A1, then 28 (days) would appear on B1. I was trying to do if statements, but I keep getting an error. Is there an easy way to do this? Thanks LGG |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I want the PMT function to calculate using 360 days not 365 | Excel Worksheet Functions | |||
4 and 5 week months | Excel Discussion (Misc queries) | |||
HELP with this function | Excel Worksheet Functions | |||
how do I calculate the days between dates? | Excel Discussion (Misc queries) | |||
HOW TO CALCULATE THE DAYS? | Excel Worksheet Functions |