| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculating days in a month
Hello,
Hope someone can help. A1 = Start date B1=End Date eg A1 = 1st Jan B1=4th April C1=Days in Jan D1=Days in Feb E1=Days in Mar etc until Dec. Therefore for the above example C1 would = 31days D1 = 28days E1 = 31days and F1 = 4 days. I have been playing around with IF and DATEDIF but I'm getting nowhere. Any help would be much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summarizing of columns for different days of month | Excel Discussion (Misc queries) | |||
| Calculating interest on number of days in the period | Excel Worksheet Functions | |||
| Calculating Production/Man Days in Excel | Excel Discussion (Misc queries) | |||
| Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
| How to Set a fix # of days per month | Excel Worksheet Functions | |||
Threaded Mode
