3G
Member
Hello-
Have 2 columns: Start Date / End Date
Currently formatted as mmmm yyyy
Start date is always the 1st of the month, end date is always the last day.
Trying to do a datedif to get weeks.
DATEDIF(A1, B1, "y")*52
Something's not working as when I copy it down to all of the other rows, it's giving me a zero for dates that are definitely a year apart. I assume the length is less than 1, thereby making "0" * 52, but, how can I get the fraction? Really, all I need to do is subtract 2 dates and get the number of weeks.
Thanks
Have 2 columns: Start Date / End Date
Currently formatted as mmmm yyyy
Start date is always the 1st of the month, end date is always the last day.
Trying to do a datedif to get weeks.
DATEDIF(A1, B1, "y")*52
Something's not working as when I copy it down to all of the other rows, it's giving me a zero for dates that are definitely a year apart. I assume the length is less than 1, thereby making "0" * 52, but, how can I get the fraction? Really, all I need to do is subtract 2 dates and get the number of weeks.
Thanks
