Hi,

You don't need anything as complicated as that. Provided you use date values, formatted however you want, you'll always be able to perform date arithmetic, probably with a SUMIF() function or some other variations. But you do need to define your requirement. For instance if someone projects 5 days for the w/c 29th December, does that count in the December total or January? Only you can decide that.

HTH