Simple Staff cost budget - 12 months forecast

Hi All,

I need some help. Which formula would i use to:

If start date cell is blank = calculate a monthly salary
If end date cell is blank = calculate a monthly salary
If start date has a date = calculate only from the start date and every month onwards
IF end date has a date = calculate only up to end date.

I used to have this formula but i have lost the spreadsheet moving jobs.

Can someone please help me.

cell L4 =
=IF(OR($B4>L$2,AND($C4<L$2, $C4<>0)),0, $H4/12)

Thanks so much ranman256 almost there. is there a way to apportion monthly salary daily if the end/start date is not 01st of the month. currently the formula divides the total cost by 12 (H/12). so if the start date is on 2nd of the month it gives me zero value at the moment .

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

can any one help please????

Still would like help from someone on this please.

Thanks so much you are genius sir!!!

You're welcome - and a belated welcome to the forum!

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' on your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.