I am trying to write a formula to count number of days in a given month based on 2 dates.
I have dates for the whole year in file. I have a start date and end date and the dates roll over to different months
Ex. April 5, 2012 is the start date and end date is June 2, 2012.
I would like to write a formula that would count the number of days (including weekends) for whats left in April, that would be 25 days, Full month of May would be 31 days and june would be 2 days.
I got one formula to work but it gives me only networkdays and i need all days.
Anyone please help.