marshybid
05-09-2008, 08:57 AM
Hi There,
Can anyone help with the following please.
I have 2 columns containing dates - Start Date and End Date - I need to add a further 3 columns - Start Month, End Month and Hours
I can not work out the correct formula to use to extract the month and year info from the original cell and format it as mmm - yyyy
I also need to calculate the nu7mber of weeks between start and end date * 37.5 to give me hours.
I have attached an example sheet for reference.
Thanks in advance. : pray2:
Marshybid
Can anyone help with the following please.
I have 2 columns containing dates - Start Date and End Date - I need to add a further 3 columns - Start Month, End Month and Hours
I can not work out the correct formula to use to extract the month and year info from the original cell and format it as mmm - yyyy
I also need to calculate the nu7mber of weeks between start and end date * 37.5 to give me hours.
I have attached an example sheet for reference.
Thanks in advance. : pray2:
Marshybid